Do not go to bed
a man and young woman go to the market pigs, dark and the rain, 20 pigs did not sell into, to a farmhouse for shelter.
young woman said: only one inconvenience.
M: big sister, to a pig.
Female: Okay, but only one.
M: I went to bed to sleep, give a pig.
female: agreed.
middle of the night men and women to discuss, I went to sleep above, women would not.
M: to the pig 2.
women allowed to require up unable to move.
awhile, man can not help, begged to move, women would not.
M: move about to the pig 2. Women agreed.
eight men moved to stop women asked why not move?
man said not a pig.
woman whispered: either I give you pig ... ...
dawn, the male whistling drive 30 (including the young woman home 10) Pigs to Market to the ... ...
Harvard Instructor Comments: To found that users of potential demand, pre-need guidance, training to user needs, resulting in the development of the investment is in line with the law.
※ ※ ※ ※ ※ ※ ※ ※
another man about the incident, determined to do the same, then go to the market pigs, dark and the rain, 20 pigs did not sell into, the young woman to a farmhouse for shelter
said: only one inconvenience.
M: big sister, to a pig
Female: Okay, but only one.
M: I went to bed to sleep, give a pig.
female: agreed.
night business men and women, I went to sleep above, women would not.
M: to the pig 2.
women allowed to require up unable to move.
awhile, man can not help, begged to move, women would not.
M: move about to the pig 2. Women agreed.
seven men moved to stop women asked why not move?
man said: were done ~ ~ ~ female: ... ...
dawn, the male head down to catch two pigs to Market to the ... ...
Harvard Instructor Comments: To be cautious with their own scale of investment, guard against money-strand breaks problem
※ ※ ※ ※ ※ ※ ※ ※
another man about the incident, determined to do the same and learn, then Viagra store with a pig go to enchant a Viagra, then starting with 19 pigs, do things, after dawn, the male whistling drive 37 (including the young woman home 18) Pigs to Market to the ... ...
Harvard Instructor comments: If companies access to financial capital to help their business capacity will be doubled.
※ ※ ※ ※ ※ ※ ※ ※
know this method more than men, Viagra in short supply, and gradually to 2 pigs for a Viagra, then three pigs for a Viagra, Viagra Viagra, announced a limited supply store always preserved.
Harvard Instructor Comments: This is inflation, but despite the purchase of Viagra, Viagra is always preserved products, from a pig to the N pigs for a Viagra, Viagra you devaluation when seen?
※ ※ ※ ※ ※ ※ ※ ※
more and more people heard the comments of Harvard mentor, began to hoard Viagra and Viagra in the secondary trading market to make money.
Harvard mentor and comment: prosperous second-hand market is the primary market to ensure continued prosperity.
※ ※ ※ ※ ※ ※ ※ ※
more and more people want to fry Viagra, Viagra price quickly rose to 16 for a pig.
Harvard mentor and Comments: The man has entered the marginal cost, in addition to the ability of self-confidence with their own wishes and future well beyond the actual current swine has zero.
※ ※ ※ ※ ※ ※ ※ ※
only one pig and some men have long replaced by Viagra, so he was told, you can use Viagra you are running a pig for this mortgage, you had a pig buy now Viagra value of 16 pigs, eight pigs at least you can do a loan, then you can buy cars and so these pigs a good thing, which can be part of your value to consume Viagra.
Harvard Instructor Comments: Good Money allows individuals to achieve financial freedom.
※ ※ ※ ※ ※ ※ ※ ※
for male pigs more and more, Viagra store decided to launch a lending Viagra sales model, even if you do not have sufficient cash pigs, as long as you dare to promise to the female housing in the night, with 16 pigs back, I can sell you Viagra first. For example, if you lack a pig, it can be due to one, after things are settling pig models, this method greatly facilitated Viagra sales.
Harvard Instructor Comments: This is the loan, so that enterprises can borrow based on future revenue options liquidity. Expand production capacity, which is the credit economy, the credit economy is based on good credit and on the basis of sustained economic growth, as long as we are disloyal, Viagra can be continuously available to everyone to use.
※ ※ ※ ※ ※ ※ ※ ※
Viagra store tasted the sweetness of the loan emboldened, and later in a pig even if you have not, as long as you promised to the woman in the room overnight, it can be by, things are after the money pay pig.
Harvard Instructor Comments: This is financial innovation, so that now people spend future money, you're old anyway, so the money you spend the next fixed.
※ ※ ※ ※ ※ ※ ※ ※
news came out, for male pigs are more and more people looking for Viagra store, great project, we turn it into a high-quality funds, foreign bond sales you also can share my earnings, how?
Viagra store feel even better results, so the company to change male pigs divided into three types, one is to take now for the pig, one pig is part of the current credit , and one is not present by the pig, issue three kinds of bonds. A lively and on. Viagra store have to buy bonds, Viagra store business is good, put the bond sales operations outsourced to another company, the company also be large fortunes, the company grew and grew, even unrealistic Viagra sales case to issue, to the stores themselves and Viagra huge cash income.
Harvard Instructor Comments: This is the professional people doing professional things, to the capital from the physical operation of business, the economy has entered a higher level.
※ ※ ※ ※ ※ ※ ※ ※
order to prevent their Zhaijuan future losses, the company decided to give it to buy the insurance, the more likely such bond sales, because once Zhai volume has issues but also available insurance company paid the insurance company a calculation, so far about the low rate of Viagra sales Wei, after all, sex is the rigid requirements must be met, as long as the commitment to accept the premium, you can get a large income, and low default risk . Wow, all of the bonds if the insurance company claims there is a problem, bond sales erupted in great, big insurance companies no reason to obtain insurance income.
Harvard Instructor Comments: This is the risk hedging, strategic alliances, improve the enterprise's risk-resisting ability, but also to protect the interests of consumers.
※ ※ ※ ※ ※ ※ ※ ※
for male pigs too, long lines waiting, the woman can not afford, said his aging mother quit, I move for a time due to numerous with Viagra male pigs.
Harvard Instructor Comments: This is an individual phenomenon, part of normal market fluctuations will not affect the entire economy.
※ ※ ※ ※ ※ ※ ※ ※
result the woman has been reluctant to move back. Part of the male pigs due to no income, had declared its willingness to exchange low-cost Viagra, Viagra 16 pigs from a sudden drop to eight pigs a Ye sell, market panic Viagra, Viagra can also drop the original, some with Viagra people bilk a result a large number of loan maturity can not return now pigs, Viagra store dizzy, have announced that a large number of borrowers owe pigs do not have, are credit default.
Harvard Instructor Comments: This is a personal act, most of the loans are high-quality crowd.
※ ※ ※ ※ ※ ※ ※ ※
a large number of subprime loans default pig, then also corresponds to their worthless bonds, corporate bonds sold bear to see a Viagra 16 pigs, which Where have since declared bankruptcy.
Harvard Instructor Comments: This is the sub-prime crisis will not affect the entire financial loans,
※ ※ ※ ※ ※ ※ ※ ※
Harvard tutor know where the company also bond on the bond insurance, insurance company to look, where it can afford to lose, and it announced plans to close down.
Harvard Instructor Comments: This is the financial crisis will not affect the real economy.
※ ※ ※ ※ ※ ※ ※ ※
a lot of people bankrupt, not consumption, through the economic downturn, the pigs did not dare to let other people, fear never to return, the market becomes more cold!
Harvard Instructor Comments: National People have the time to bleeding, although those who sell Viagra, selling bonds, and selling insurance at the time made a fortune in money, and now come up with funnel, and if we do not help them pay , our future is the biggest victims.
※ ※ ※ ※ ※ ※ ※ ※
Viagra Monopoly Board decided to borrow 700 billion to the National People's pigs to save the market, the market remains unchanged, there are no pig and pig are very angry, who took us pig?
Harvard Instructor Comments: early to tell you, why do not control? The only way is to find a few foreign pig farmers to the image of a responsible big country to note pig pig, otherwise we all have finished!
※ ※ ※ ※ ※ ※ ※ ※
later: It is said that women have moved to settle in China, in addition to several graduate with a Harvard professor is also gold in China.
Reading Tips: Pig in cash, Viagra is the house.
Wednesday, June 29, 2011
Thursday, June 9, 2011
Ping An Bank Credit Card free of charge , additional gift
. .
for Ping An Bank credit cards, gift :
public transport accident insurance :
* accident death insurance :
aviation accident insurance 50W
ships rail train accident insurance 20W
bus accident 5W
* accident medical insurance
5,000 public health accidents
hospital allowance 30 yuan / day, 180 days
gas accident insurance :
* accident death insurance
per 5W, 15W
* maximum per accident medical insurance
2000 yuan / person , per household maximum 6,000 yuan
hospital allowance 30 yuan / day, maximum Peifu 180 days
become effective the day the insurance card activation
72 hours before reporting the loss lost card protection
double insurance : credit card spending ( mere signature confirmation ) + credit card loss protection is taken to be robbed (by check is password) loss of security , allowing you to use the card more at ease.
high limit : the protection of the fixed maximum amount of your credit limit up to a maximum 50,000 yuan , for your share of the loss risk.
Tips: If you find that the card is lost, please call the credit card customer service hotline report the loss of peace in order to avoid losses.
Enquiry Report Phone : 95511
the most convenient way of two payments : payments & Alipay online payments can be a convenience store
for Ping An Bank credit cards, gift :
public transport accident insurance :
* accident death insurance :
aviation accident insurance 50W
ships rail train accident insurance 20W
bus accident 5W
* accident medical insurance
5,000 public health accidents
hospital allowance 30 yuan / day, 180 days
gas accident insurance :
* accident death insurance
per 5W, 15W
* maximum per accident medical insurance
2000 yuan / person , per household maximum 6,000 yuan
hospital allowance 30 yuan / day, maximum Peifu 180 days
become effective the day the insurance card activation
72 hours before reporting the loss lost card protection
double insurance : credit card spending ( mere signature confirmation ) + credit card loss protection is taken to be robbed (by check is password) loss of security , allowing you to use the card more at ease.
high limit : the protection of the fixed maximum amount of your credit limit up to a maximum 50,000 yuan , for your share of the loss risk.
Tips: If you find that the card is lost, please call the credit card customer service hotline report the loss of peace in order to avoid losses.
Enquiry Report Phone : 95511
the most convenient way of two payments : payments & Alipay online payments can be a convenience store
Wednesday, May 25, 2011
All local storm thin ( girls must see )
by chin: is the rise! Must make awkward upward, feeling his chin and neck tightened, and then lay down for 5 seconds, do 20 to 40 the next day. Week will see the results.
medial upper arm: two small dumbbells (available mineral water instead), in the hand, raised his arm and upper arm close to the ear, and then toggle, and then straight arm. This is it. 3 sets per day, a group of 15.
cut back:
1. to prepare two dumbbells, standing posture, his arms drooping naturally, holding the dumbbell, arm moves back to deal with the things, that the dumbbell side of the chest. A group of 15, 3 sets per day.
2 .. standing, his arms drooping naturally, palm of the hand holding the dumbbell back, back lift. Do this action to keep the arm is straight. A group of 15, 3 sets per day.
these two actions can exercise to the back, but more difficult to cut back fat, the general movement to this area is difficult to fully exercise, MM need to persist for some time.
the upper abdomen:
on the abdomen is the part of the stomach. The easiest way is to sit within. Note that not sit from the If you do this exercise while sitting up, not good for your spine, and do not put his hand behind the time, his hands held onto the ears on it, or of the cervical spine injury. Do at least 3 groups per day, a group of 20.
lower abdomen:
is the Lying down, legs straight, feet together, slowly lift, and body into a 90-degree angle, then slowly down. This action will make them tired, but can reduce the front side of the fleshy thigh. Do at least 2 groups per day, a group of 15.
reducing the waist on both sides:
1. one is shaking hula hoop (to last 30 minutes of aerobic exercise started after the consumption of fat, so exercise at least 30 minutes), after a week obviously feel the muscles tightening on both sides .
2. standing, feet slightly wider than shoulder width apart, arms reach peace, the body was And then bending the waist with his left hand to touch the left ankle, then stand up straight, for the right. Do it will feel the muscles on both sides of the waist has stretched feeling. All about a group of about a day to do 30.
Less hip: lying on the bed, legs straight, do take water swimming action, alternating legs lifted up, slower movements, hip not to leave bed. Click once on each side, a group of under 15 a day to do 3 to 4 groups.
Less hip: the side kick. Standing, left leg lifted to the side, keeping the knees toward the front. Slowly lift to the highest position you can afford, and then slowly down. Under the side of a group of 15, daily 2 to 3 groups.
Less thigh:
1, inner thighs: do squat exercise. Standing, feet shoulder width apart, toes out, the number of 1234 slowly squat, Dundao and parallel to the floor sincerity. Number 5678 and then slowly stand up. Do not squat lift when the heel, must fall on the floor, and be slow. Do 15 each day, doing 3 to 4 groups.
2, front thigh: ibid. Because this action can exercise to the front thigh muscles.
3, back of the thigh: stand. After the kick to do the action. When the action should be slow. An eight-beat as one, each doing 15 a day, 3 to 4 groups. Flexibility of each person's body is different not Taimian Jiang himself, so as not to strain muscles.
reduce the legs: how much fat leg test is simple, relaxed leg with your fingers to pinch the site of a small calf, can easily lift and fat layer to explain your legs are fat type, need to cut by a ~ If the fat layer is very thin, just the muscle becomes very thick legs, and that is the muscle type.
1, fat-type: The most effective way to tiptoe, a group of under 20, do 4 per day. Essentials is action to slow, hips do not tilt. Tiptoe around 3 seconds after the stop. Done after exercise, remember to gently shake parts of the calf muscles to relax.
2, muscle type: it is very difficult to cut up, for the muscle-type MM, can only suggest not to do a great leg exercise intensity, high heels and want, to avoid too much tension in the muscles become more thick.
well, exercise, exercise when you are going to feel the site has not in motion, such as exercise thigh, you have to squat at the same time to feel your thigh muscles are not tightened, done after exercise, this site has not sour. If so, that you have to this part of the exercise, if not to state your position not to make their own adjustments
medial upper arm: two small dumbbells (available mineral water instead), in the hand, raised his arm and upper arm close to the ear, and then toggle, and then straight arm. This is it. 3 sets per day, a group of 15.
cut back:
1. to prepare two dumbbells, standing posture, his arms drooping naturally, holding the dumbbell, arm moves back to deal with the things, that the dumbbell side of the chest. A group of 15, 3 sets per day.
2 .. standing, his arms drooping naturally, palm of the hand holding the dumbbell back, back lift. Do this action to keep the arm is straight. A group of 15, 3 sets per day.
these two actions can exercise to the back, but more difficult to cut back fat, the general movement to this area is difficult to fully exercise, MM need to persist for some time.
the upper abdomen:
on the abdomen is the part of the stomach. The easiest way is to sit within. Note that not sit from the If you do this exercise while sitting up, not good for your spine, and do not put his hand behind the time, his hands held onto the ears on it, or of the cervical spine injury. Do at least 3 groups per day, a group of 20.
lower abdomen:
is the Lying down, legs straight, feet together, slowly lift, and body into a 90-degree angle, then slowly down. This action will make them tired, but can reduce the front side of the fleshy thigh. Do at least 2 groups per day, a group of 15.
reducing the waist on both sides:
1. one is shaking hula hoop (to last 30 minutes of aerobic exercise started after the consumption of fat, so exercise at least 30 minutes), after a week obviously feel the muscles tightening on both sides .
2. standing, feet slightly wider than shoulder width apart, arms reach peace, the body was And then bending the waist with his left hand to touch the left ankle, then stand up straight, for the right. Do it will feel the muscles on both sides of the waist has stretched feeling. All about a group of about a day to do 30.
Less hip: lying on the bed, legs straight, do take water swimming action, alternating legs lifted up, slower movements, hip not to leave bed. Click once on each side, a group of under 15 a day to do 3 to 4 groups.
Less hip: the side kick. Standing, left leg lifted to the side, keeping the knees toward the front. Slowly lift to the highest position you can afford, and then slowly down. Under the side of a group of 15, daily 2 to 3 groups.
Less thigh:
1, inner thighs: do squat exercise. Standing, feet shoulder width apart, toes out, the number of 1234 slowly squat, Dundao and parallel to the floor sincerity. Number 5678 and then slowly stand up. Do not squat lift when the heel, must fall on the floor, and be slow. Do 15 each day, doing 3 to 4 groups.
2, front thigh: ibid. Because this action can exercise to the front thigh muscles.
3, back of the thigh: stand. After the kick to do the action. When the action should be slow. An eight-beat as one, each doing 15 a day, 3 to 4 groups. Flexibility of each person's body is different not Taimian Jiang himself, so as not to strain muscles.
reduce the legs: how much fat leg test is simple, relaxed leg with your fingers to pinch the site of a small calf, can easily lift and fat layer to explain your legs are fat type, need to cut by a ~ If the fat layer is very thin, just the muscle becomes very thick legs, and that is the muscle type.
1, fat-type: The most effective way to tiptoe, a group of under 20, do 4 per day. Essentials is action to slow, hips do not tilt. Tiptoe around 3 seconds after the stop. Done after exercise, remember to gently shake parts of the calf muscles to relax.
2, muscle type: it is very difficult to cut up, for the muscle-type MM, can only suggest not to do a great leg exercise intensity, high heels and want, to avoid too much tension in the muscles become more thick.
well, exercise, exercise when you are going to feel the site has not in motion, such as exercise thigh, you have to squat at the same time to feel your thigh muscles are not tightened, done after exercise, this site has not sour. If so, that you have to this part of the exercise, if not to state your position not to make their own adjustments
Tuesday, May 24, 2011
2010 is too small to force the hard nibbling !
[Image
1 sore and not necessarily a virgin, must be smiling bitch.
2 Big Sleep, you off I'm off.
3 shallow bastard and more, over and over is the big brother.
not social people, social chatter actually bearish nibbling
4 life and death, against on the stem.
5 really not as good as the red notes, but of emotional needs.
6 play Hey, want to open, clap meal Xiaoping beat.
7 I do not know the depth of water is not tested, people do not pay ungrateful.
8 men wrist watch, women watch face.
9 drawing near, it is better to spend money Kusakabe. Although the main
10 flowers, I'll loose soil.
money man, money man hard
11 the world's a mess, put
12 plain to see who I am as the money for dirt, my father saw me as a septic tank.
13 Daikin small watch chain, three meals a day, a small barbecue.
14 brothers as brothers, women as clothes. Who moved my foot, my Pa who clothes.
15 is not who can do without, who does not fit who he is.
16 through the summer youth, who remember what year?
17 Life is too short to be sexy.
18 hope as fire, smoke disappointment, life is like seven ignition, eight smoke.
19 to lose to lose to the pursuit of happiness marry to marry
20 life's long road, has been lost.
21 classes, this section of physics, I'm sorry, the next class to continue.
22 I am a long hard look good, you have to be patient to see.
23 I can give up the choice, but can not give up.
24 world is dirty, how sad?
25 brothels full, because the people alone.
26 and people exposed to more and more like a long time, the dog, the dog will always be a dog, sometimes not the people.
27 sorts of flowers are red, people and dogs are different.
28 Behind every successful man,
29 heart to love you neighbor, but do not get him caught.
30 Do not give me swear, I'm afraid you are struck by lightning when
31 small toys when my friends grew up friends to take me as toys.
32 teeth is difficult to get out of there in addition to love!
33 call, like life, is not you hang up that I'll hang up.
34 I like Naruto because of a death on the death of a Japanese village.
35 people do not want to be slaves, a slave willing to do the RMB.
36 can not hold the sand, So Young it.
37 tired it? Tired on the right, is left to comfort the dead.
38 beautiful woman is the advantage of long, beautiful life is capable.
39 if I can forgive you vulgar, then you can forgive my loaded to force it?
40 brother who never said, I only said that myth. Husband who is who, all TM is temporary.
41 you engage in the arts, I'm on you, called in-depth art.
42 Columbia mingled now starting to get the next release, only chopsticks.
43 things I do regret it, I only do things you regret.
44 triad you how it? Damn it, I would not join the party?
45 God is not your small raccoon, not to play your sport.
46 something indisputable, the surface subject, secretly resistance.
47 ads is to tell others, so to spend money.
48 between the role of force, in addition to the power of love.
49 hyperopic eyes we are all blurred the nearest well-being.
50 as long as the prison is not yellow, I continued to wild.
51 days of my life that I could not help, the day I'm off to destroy my day.
52 long nasty women like men, not long bad man.
53 aim at top of the mountain, the mountain scenery is not greed.
54 knees of their choice have to finish the road. Only the first one I, who do not do the second.
55 that allow the squandering is called the age of youth.
56 youth gambling Do not take tomorrow, lost no tomorrow.
57 man has been strong, women have lost 忽悠.
58 Love is like a ghost, I believe that many people, but few people see.
59 a person to show off what, for lack of anything inside.
60 Do not be obsessed brother, sister in law will beat you up.
61 do not call me arrogant, I just do not deal with the beast.
62 a woman is in trouble, men like asking for trouble.
63 For their own good points, because life is not long, the people around him better, since my next life will not necessarily touch a heartless bitch
64 interpretation of the world's joys and sorrows but the play was sub-nonsense people like to sing angry dirge.
65 to see your face, made you feel when your parents did not seriously.
66 said for impotence, premature ejaculation is only a wishful thinking.
67 Department of like waving the flag, do not spend money Lv the B.
68 idle youth, grow up to be prostitutes.
69 male bosses always want to side with a female secretary, something Secretary of the dry, nothing to do secretary.
70 two blood type B, resulting in the 2B type it?
71 no one take my hand, I guess pocket.
72 contraceptive effect is not successful then the adult.
73 empty head does not matter, the key is not to water.
74 you say is the beginning of the end of the countdown.
75 stupid and not stupid, mainly to see you will not play the fool.
76 I was young and need your advice, but do not need you around.
77 men want to have money, and no one fate.
78 with her husband how, and with the goalkeeper and still can not score it
79 people put money into the grave, but the money can put people into the grave.
80 so-called loyalty, betrayal of the chips is not enough.
81 behind the scenery, not the vicissitudes of life that is dirty.
82 turned back and who naturally could not walk by themselves.
83 there is a beast, looked like a human.
84 feet but not feeling tired, but not the result of the failure of the will.
If you can not fly, the ideal life had become a drag on the wings.
85 backing down the mountain, everyone will be run by only their most reliable
86 languages all kinds of chatter, a variety of small nibbling a variety of sets.
various small rooms all open, all women of various Hi.
87 community-line, and Costa are like. But the brother is not your object.
88 I like Detective Conan, for one death to the death of one said I; I like to watch Naruto, because he died a death, a team of Japanese; I most like to see Pearl as a dead planet to death a Japanese
89 close your eyes, I saw my future.
90 as long as you Gansi, I'm buried.
91 chickens now dress like students, like students to wear the chicken.
92 Let me dust has settled, with silence buried in the past.
93 dark and slippery, or social.
94 wife is a tree, be sure to hold.
bird lover, do not feed.
95 handsome car, it is chess. And money room, it was banks.
96 a woman is the wife a good mix, getting along is not good bitch.
look past all the goods, old sister who ever you want.
97 Columbia is only a bureau, and you are entranced. Brother obsession
not legend, but legend of a woman so beautiful
98 men conquered with stockings, men with stockings to conquer the bank!
99 is a ghost not loading, is the people do not play God. Do not pretend to force
tight, is not loaded cargo net.
100 generally normal guy, proud of my daughter while generally rely
1 sore and not necessarily a virgin, must be smiling bitch.
2 Big Sleep, you off I'm off.
3 shallow bastard and more, over and over is the big brother.
not social people, social chatter actually bearish nibbling
4 life and death, against on the stem.
5 really not as good as the red notes, but of emotional needs.
6 play Hey, want to open, clap meal Xiaoping beat.
7 I do not know the depth of water is not tested, people do not pay ungrateful.
8 men wrist watch, women watch face.
9 drawing near, it is better to spend money Kusakabe. Although the main
10 flowers, I'll loose soil.
money man, money man hard
11 the world's a mess, put
12 plain to see who I am as the money for dirt, my father saw me as a septic tank.
13 Daikin small watch chain, three meals a day, a small barbecue.
14 brothers as brothers, women as clothes. Who moved my foot, my Pa who clothes.
15 is not who can do without, who does not fit who he is.
16 through the summer youth, who remember what year?
17 Life is too short to be sexy.
18 hope as fire, smoke disappointment, life is like seven ignition, eight smoke.
19 to lose to lose to the pursuit of happiness marry to marry
20 life's long road, has been lost.
21 classes, this section of physics, I'm sorry, the next class to continue.
22 I am a long hard look good, you have to be patient to see.
23 I can give up the choice, but can not give up.
24 world is dirty, how sad?
25 brothels full, because the people alone.
26 and people exposed to more and more like a long time, the dog, the dog will always be a dog, sometimes not the people.
27 sorts of flowers are red, people and dogs are different.
28 Behind every successful man,
29 heart to love you neighbor, but do not get him caught.
30 Do not give me swear, I'm afraid you are struck by lightning when
31 small toys when my friends grew up friends to take me as toys.
32 teeth is difficult to get out of there in addition to love!
33 call, like life, is not you hang up that I'll hang up.
34 I like Naruto because of a death on the death of a Japanese village.
35 people do not want to be slaves, a slave willing to do the RMB.
36 can not hold the sand, So Young it.
37 tired it? Tired on the right, is left to comfort the dead.
38 beautiful woman is the advantage of long, beautiful life is capable.
39 if I can forgive you vulgar, then you can forgive my loaded to force it?
40 brother who never said, I only said that myth. Husband who is who, all TM is temporary.
41 you engage in the arts, I'm on you, called in-depth art.
42 Columbia mingled now starting to get the next release, only chopsticks.
43 things I do regret it, I only do things you regret.
44 triad you how it? Damn it, I would not join the party?
45 God is not your small raccoon, not to play your sport.
46 something indisputable, the surface subject, secretly resistance.
47 ads is to tell others, so to spend money.
48 between the role of force, in addition to the power of love.
49 hyperopic eyes we are all blurred the nearest well-being.
50 as long as the prison is not yellow, I continued to wild.
51 days of my life that I could not help, the day I'm off to destroy my day.
52 long nasty women like men, not long bad man.
53 aim at top of the mountain, the mountain scenery is not greed.
54 knees of their choice have to finish the road. Only the first one I, who do not do the second.
55 that allow the squandering is called the age of youth.
56 youth gambling Do not take tomorrow, lost no tomorrow.
57 man has been strong, women have lost 忽悠.
58 Love is like a ghost, I believe that many people, but few people see.
59 a person to show off what, for lack of anything inside.
60 Do not be obsessed brother, sister in law will beat you up.
61 do not call me arrogant, I just do not deal with the beast.
62 a woman is in trouble, men like asking for trouble.
63 For their own good points, because life is not long, the people around him better, since my next life will not necessarily touch a heartless bitch
64 interpretation of the world's joys and sorrows but the play was sub-nonsense people like to sing angry dirge.
65 to see your face, made you feel when your parents did not seriously.
66 said for impotence, premature ejaculation is only a wishful thinking.
67 Department of like waving the flag, do not spend money Lv the B.
68 idle youth, grow up to be prostitutes.
69 male bosses always want to side with a female secretary, something Secretary of the dry, nothing to do secretary.
70 two blood type B, resulting in the 2B type it?
71 no one take my hand, I guess pocket.
72 contraceptive effect is not successful then the adult.
73 empty head does not matter, the key is not to water.
74 you say is the beginning of the end of the countdown.
75 stupid and not stupid, mainly to see you will not play the fool.
76 I was young and need your advice, but do not need you around.
77 men want to have money, and no one fate.
78 with her husband how, and with the goalkeeper and still can not score it
79 people put money into the grave, but the money can put people into the grave.
80 so-called loyalty, betrayal of the chips is not enough.
81 behind the scenery, not the vicissitudes of life that is dirty.
82 turned back and who naturally could not walk by themselves.
83 there is a beast, looked like a human.
84 feet but not feeling tired, but not the result of the failure of the will.
If you can not fly, the ideal life had become a drag on the wings.
85 backing down the mountain, everyone will be run by only their most reliable
86 languages all kinds of chatter, a variety of small nibbling a variety of sets.
various small rooms all open, all women of various Hi.
87 community-line, and Costa are like. But the brother is not your object.
88 I like Detective Conan, for one death to the death of one said I; I like to watch Naruto, because he died a death, a team of Japanese; I most like to see Pearl as a dead planet to death a Japanese
89 close your eyes, I saw my future.
90 as long as you Gansi, I'm buried.
91 chickens now dress like students, like students to wear the chicken.
92 Let me dust has settled, with silence buried in the past.
93 dark and slippery, or social.
94 wife is a tree, be sure to hold.
bird lover, do not feed.
95 handsome car, it is chess. And money room, it was banks.
96 a woman is the wife a good mix, getting along is not good bitch.
look past all the goods, old sister who ever you want.
97 Columbia is only a bureau, and you are entranced. Brother obsession
not legend, but legend of a woman so beautiful
98 men conquered with stockings, men with stockings to conquer the bank!
99 is a ghost not loading, is the people do not play God. Do not pretend to force
tight, is not loaded cargo net.
100 generally normal guy, proud of my daughter while generally rely
Monday, May 23, 2011
Pay homage to the feelings I went
Vientiane chosen by human love sky
or should hope so keep a keen
I believe that there are a kind of love within your reach
and forever beyond the grasp in the hand grip of passion which sometimes
will be reduced to ashes but in my heart can never grow old
yearning lust crazy because all the tears are vain Siyi
I remember a friend once asked me what type of love figs?
This is what I have been afraid to touch the problem, not afraid of him too heavy, but filled my mind how the text can not interpret it Xinsui. Some may find it less than a short time, such as the breeze blowing means tip; some of the time and thick enough that it does not open, like Mei Xiang fascinated mind. that is why, when some of the problems of love can not always explicit, but clinging to the faint at heart!
What is love? The passion is fleeting it? Finally in the hand will be burnt to ashes thing? Life time is in my heart grow new things?
love what is it? Daiyu antecedent is the striking cough blood in the veil? Zhao curtain or westerly, thinner than yellow? Or just before or since Meng Jiang surprise those who spent months rolling tears shame?
and love of our age, perhaps until the end of life, will mark the end of the period. Love and memory like water and ice. Young, we love chasing the water, when the Chinese grow old, not young, love ice crystals like memories in our hearts accumulated precipitation, sunset, ship dock, we will Chujingshengqing, past one by one surface ... ...
love has always been a very complicated emotion, the moment from the heart, mixed emotions too much, back and forth sweet and bitter battle, the impression of endless ... ... read some prose about love, description love, hate, and indifference relations: Because I have deeply loved, so I learned to hate, when I was really calm and those who love began negligible, so I learned to forget, and gradually become numb and cold ... ... The results of love are only two: combine separation; until Xinrusihui, will slowly come to accept the cruel reality Looking back at the road traveled, loved, hated, painful, that reveals traces of a broken heart an attachment without complaint ... ...
love really is beautiful because they can not have it? Love and be loved sometimes in conflict, when the two are not mutually exclusive, must give up one, in the end will hurt! When the face I love and who love me, I would choose the hurt who? How sad, I love a mystery, I'm not sure of her feelings, but the real feelings of love but my people really pay, because I too deeply in love with a person, so I understand that is painful to lose heart, so to retain the most pure emotion, in the years to come pay homage to, journeying waiting for the people that I love, silently comforted the people that love me ... ... I think a
Shu Ting for the
or should hope so keep a keen
I believe that there are a kind of love within your reach
and forever beyond the grasp in the hand grip of passion which sometimes
will be reduced to ashes but in my heart can never grow old
yearning lust crazy because all the tears are vain Siyi
I remember a friend once asked me what type of love figs?
This is what I have been afraid to touch the problem, not afraid of him too heavy, but filled my mind how the text can not interpret it Xinsui. Some may find it less than a short time, such as the breeze blowing means tip; some of the time and thick enough that it does not open, like Mei Xiang fascinated mind. that is why, when some of the problems of love can not always explicit, but clinging to the faint at heart!
What is love? The passion is fleeting it? Finally in the hand will be burnt to ashes thing? Life time is in my heart grow new things?
love what is it? Daiyu antecedent is the striking cough blood in the veil? Zhao curtain or westerly, thinner than yellow? Or just before or since Meng Jiang surprise those who spent months rolling tears shame?
and love of our age, perhaps until the end of life, will mark the end of the period. Love and memory like water and ice. Young, we love chasing the water, when the Chinese grow old, not young, love ice crystals like memories in our hearts accumulated precipitation, sunset, ship dock, we will Chujingshengqing, past one by one surface ... ...
love has always been a very complicated emotion, the moment from the heart, mixed emotions too much, back and forth sweet and bitter battle, the impression of endless ... ... read some prose about love, description love, hate, and indifference relations: Because I have deeply loved, so I learned to hate, when I was really calm and those who love began negligible, so I learned to forget, and gradually become numb and cold ... ... The results of love are only two: combine separation; until Xinrusihui, will slowly come to accept the cruel reality Looking back at the road traveled, loved, hated, painful, that reveals traces of a broken heart an attachment without complaint ... ...
love really is beautiful because they can not have it? Love and be loved sometimes in conflict, when the two are not mutually exclusive, must give up one, in the end will hurt! When the face I love and who love me, I would choose the hurt who? How sad, I love a mystery, I'm not sure of her feelings, but the real feelings of love but my people really pay, because I too deeply in love with a person, so I understand that is painful to lose heart, so to retain the most pure emotion, in the years to come pay homage to, journeying waiting for the people that I love, silently comforted the people that love me ... ... I think a
Shu Ting for the
Wednesday, May 18, 2011
Use spreadsheet skills!
! Practical ah! ! !Use spreadsheet skills! ! Practical ah! ! ! Thank you, friends to share
Of: ●. ●. Has been shared 4 times Comments (0) Copy this link to report Excel Advanced sharing tips
1. Editing skills
2. Unit cell contents of the combined
3. conditions indicate
4. custom format
5. Drawing Function Image
6. custom functions
7. Matrix
8. automatically switch input
9. batch delete empty lines
10. how to avoid the error message
11. macro use
12. icon application skills
1, editing skills
1 editing skills
(1) fraction of the input
If the direct input of January 5
(2) sequence quotation marks), then enter
(3) the date of the input
If you want to enter the If you want to enter the current date, click
(4) fill streak
workbook if you want to join in the beautiful horizontal stripes, can use the alignment of the filled function. First filled in a cell of
Figure 1
(5) multiple sheets to enter the same content in several worksheets
enter the same data in the same location, you can select a worksheet, and then hold down the Ctrl key, then click the window to the bottom left corner of the Sheet1, Sheet2 ...... to directly select the input the same content multiple sheets, then in any one of them to enter these same worksheet data, then the data will automatically appear in the table selected among other work. After input finished, press the Ctrl key on the keyboard, then use the left mouse button click on the selected multiple worksheets, work table to remove these links, or in a form input data will then appear in the election the other work table.
(6) cells do not continuously fill the same data
select a cell, hold down the Ctrl key, right click the other cells, it will select all those cells the. Enter data in the edit area, then hold down the Ctrl key while you tap Enter, in all the selected cells have emerged in the data.
(7) to display the formula in cell
data in the table if the majority of work is generated by a formula and want to quickly know the formula for each cell in the form of, for editing , you can do: Use the left mouse button click on At this time the division of labor in each cell that come. If you want to restore the display of calculated results to re-set
Figure 2
(8) Select the text using Ctrl + *
a work table, if there are many data tables, you can select the table by a cell, and then press Ctrl + * key to select the entire table. Ctrl + * the selected region: According to the selected cell to the surrounding radiation data involved are the largest regional cell. So that we can easily and accurately select the data table, and effective method to avoid dragging large range of cells selected screen Luangun phenomenon.
(9) quickly remove the contents of the cell
If you want to delete the contents of the cell content and its format and comments, can not simply be applied to the cell selected, then press the Delete key way to go. To completely remove the cells, using the following method: you want to remove the selected cell or range of cells; click the
2, the combined cell contents
needed, and sometimes want to B and C list the contents of the column to merge, if the number of rows less, can be directly with the
solution is: In the C line, insert a blank line (if the D column is not content to operate directly in the D column), in D1, enter , C, and the two columns. Select cell D1, the cell with the mouse to point the bottom right corner of the small box B series and C series combined. Then do not just put the first B and C column remove column, the first column of the results of D should copy it, and then Time you delete B, C, D columns.
The following is a With AutoCAD drawing, some people like the coordinate point is stored in EXCEL, called when drawing curves in these parameters. Stored data format is merged into C column, enter in C1: = A1 &All contents of the combined (see Figure 3-4).
merge the contents of different cells, there is a way is to use CONCATENATE function, the function of certain text string into a string, the specific operation for the . For example, assume that the investigation in a river ecosystem in the table, B2 contains ,
Figure 3 Figure 4
3, conditions indicate
we know, the use of If the function can be achieved in accordance with the conditions of display. A common example is when the teachers in student achievement statistics, want to enter scores below 60, can appear as This effect, the use of IF functions can be easily achieved. Assumption results in the A2 cell, determine the results in cell A3. Then in cell A3 enter the formula: = if (A2 <60,
For example, if you type: = if (A2 <60,
If you enter = if (A2 <60, to four grades.
another example, the formula: = if (SUM (A1: A5> 0, SUM (A1: A5), 0) this style on the use of a nested function, meaning that, when A1 to A5 and large at 0, returns this value if less than 0, it returns 0. Another point to draw your attention: The above symbols are the half-angle, and the IF with no spaces between brackets.
4,
Excel custom format by default in a lot of useful data formats, and can basically meet the requirements of use, but some special requirements, such as highlighted in some important data or information, set the display conditions, we must use a custom format function to complete. Excel custom format using the following general model: a positive number format, negative format, zero format, text format, in this general model, including three numbers and a text segment segment: use of data greater than zero positive number format; less than zero data using a negative format; zero data using a zero format; enter the body cells to use text format. We can also use test, add descriptive text and color to expand the use of custom format general application of the model.
(1) use of color in a custom format to a paragraph set the color, simply add the paragraph with enclosed in square brackets, color name or color number. Excel recognize the color is named: [black], [Red], [White], [Blue], [Green], [blue] and [magenta]. Excel is also recognition Press [Color X] specified color, where X is a number between 1-56, representing 56 kinds of colors (Figure 5).
Figure 5
(2) add description text After the input digital data to automatically add text, using a custom format: Excel numeric data input position relative to add text.
(3) create a conditional format to the six conditions of the logical symbols to design a format: ), > = The corresponding figures using the format specified in paragraph, paragraph 3 of the remaining numbers to use format. If the test contains only one condition, they have different situations according to specific analysis.
custom format of the generic model is equivalent to the following formula : [>; 0] is the number of formats; [<; 0] negative format; zero format; text format.
an example is given below: Select one, and then click the The #, # # 0.00); , will be displayed in the cell shows $#,## 0.00); [blue] color. If you enter br>
another example, assume that the ongoing settlement of accounts, you want to use the blue more than $ 50,000 account balance, negative values shown in brackets in red, the rest use the default value color display, you can create the following format: 0.00_) used in the preparation of the budget, need converted from grams kilograms, tons, then you can define the following format: _k_m
In addition, we can use a custom format to achieve the purpose of hiding the input data, such as the format Hide all the input values. custom format only changes the appearance of the display of the data, the data does not change the value, that does not affect the calculation of data. flexible use of a good custom format function, will give a great deal of practical work convenient.
5, drawing functions for teaching image
friends will encounter problems drawn function curve now! If you want to draw quickly and accurately a function curve, a chart can make use of EXCEL functions, it can make you draw the curve of both standard and beautiful. You have to ask, is not hard to learn it? fact, this is not difficult, can be very simple, do not believe you told me to try.
to draw the y = | lg (6 + x ^ 3) | of the curve, for example, the method is as follows: in a blank worksheet, enter the function of self- variables: A column in the cell A1 enter Arithmetic input method, enter the first two values, given the number of variables and the number from the step between, and then select the two cells A2 and A3, so that the two into a rectangle with a black border, and then This is a black rectangle with the mouse to point to the lower right corner of the small box input function type: B1 cells in column B enter the general functional form of written expression, y = | lg (6 + x ^ 3) |; in cell B2 enter the , B2 Genei Ma calculated on the results obtained. At this time, and then select cell B2, so that the cursor point to the lower right corner of the rectangle B2 place to complete the calculation of function values.
Figure 7
drawn curve: Click the toolbar 7), then in the Note: How to determine the initial value of the independent variables, the step between data points is the number, this is according to the specific characteristics to determine the function, which is the ability of the test users. If you want to function extremely quickly found value or see its development trend, the data presented do not necessarily have to be a point arithmetic, can be arbitrarily given.
from simple to complex logarithmic trigonometric functions, exponential functions, are EXCEL can be used to draw curves. If available, you can also use EXCEL to complete the determinant, the matrix of the various calculations, a simple integral operation, the use of iteration of a function value (such as x ^ 2 = x ^ 7 +4 , can be iterative method to solve x value), and so on, all things related to computing, to find EXCEL to help, it will give you a satisfactory answer.
6, Although the custom function
already a large number of built-in Excel function, but sometimes may also encounter some computational functions can be used without the case. If a company uses a special mathematical formula to calculate the discount products buyers If there is a function to calculate how much more convenient? said the following about how to create such a custom function.
custom functions, also called user-defined functions, Excel is the most innovative and attractive features one of the following Visual Basic we create a function module. In the following example, we give each person the amount by a factor, if it is working meals at work, and beat the tickets; if it is working overtime meal hit half of the amount; if it is a rest day to dinner, hit Jiuzhe. First, open the * tatol ElseIf rr = > Then close the editor, as long as we enter in the appropriate column rrr (F2, B2), then the amount of money even after the kick off out (Figure 10).
Figure 10
< / p>
7, Matrix
Excel's powerful computing capabilities, not only simple arithmetic, it can be an array, matrix calculations.
(1 ) the definition of arrays and matrices
matrix is not a number, but an array. In Excel, the array of domain occupied by a unit, the unit field with large brackets, such as {A1: C3}, in order and the general unit Domain A1: C3 phase difference. set the selected cell when the first field, press Shift + Ctrl + Enter key to automatically generate large parentheses, an array of fields to be confirmed.
a cell is a variable, a unit of the domain can be as a set of variables. In order to calculate the convenience, a set of variables to an array of the best name. For example A = {A1: C3}, B = {E1: G3} and so on. array name setup steps are: an array of fields selected , click the enter the name on the line.
matrix function is Excel-specific modules for matrix calculations. use the The calculate all the matrix elements corresponding to the product of the sum.
Figure 11
(2) the basic calculation of matrix computation and matrix array
very different calculations, such as the following example, A and B are defined array, as the two arrays are 3 × 3, the output is 3 × 3 unit cells. calculated results when the first output of the selected matrix domain of 3 × 3 of the range of cells, and then enter the formula. If you enter and . br> In a worksheet, the data is often both, there are text, so that input back and forth in the need to repeatedly switch between English and Chinese input method is very troublesome. If you want to enter something great regularity such as this column is all words, all Chinese to explain the next column, you can use the following method for automatic switching. is:
(1) Select the column to type in English, click Select the Click English automatically switch between input methods.
9, bulk delete blank lines
sometimes we need to delete Excel workbook in the blank line, the general practice is to eleven to find empty lines, and then delete it. If the number of rows in the table a lot of work, this is very inconvenient. We can use the Insert a new blank line, then press Ctrl + A keys to select the entire worksheet, right-click have suffered a drop-down list box, in a typical drop-down list box, select the column br> In all cases the data have been selected, click the Data one of the blank cells, while the other columns of data and blank cells are not affected, you can copy the first column, paste it to a blank worksheet, according to the above method to delete all blank lines, and then Copy this column and paste it into the original position of the corresponding worksheet.
10, how to avoid the error message
enter the formula in Excel, sometimes not correctly calculated results, and in the cell displays an error message, the production of these errors, some due to the formula itself, and some are not. Here's introduce some common error messages, and proposed ways to avoid mistakes.
1) :####
mean error value: Enter the data into a cell or cell formula is too long the result is too large, so that the results show no less than in the cell. Date and time format, or the cell subtraction, there has been negative.
solution: increase the width of the column so that the results can be fully displayed. If it is subtracted from the date or time had caused negative , you can change the format of the cell, such as to text format, the result is a negative amount of time.
2) error value: # DIV / 0!
meaning: trying to divide by 0 . This error is usually associated with the following situations: the divisor is 0, the divisor used in the formula or the empty cells contain a zero value cell reference cells.
solution: Modify the cell references , or used as a divisor input cell value is not zero.
3) error value: # VALUE!
meaning: the text-input mathematical formula item. If you use incorrect parameters or operator, or when performing an automatic correction function can not correct the formula for the formula, will produce an error message # VALUE!.
solution: At this time the formula or function should be required to confirm the operator or parameters correctly, and that a formula references a cell contains a valid value. For example, cell C4 has a numeric or logical values, cell D4 contains the text, then the formula = C4 + D4, the system can not convert the text to the correct data type, which returns the error value # VALUE!.
4) error value: # REF!
meaning: delete the formula referenced by the range of cells.
The solution: restore the referenced cell range, or re-set the reference range.
5) error value: # N / A
meaning: no information can be used to run the calculation. In modeling, the user can enter in a cell # N / A, to show that is waiting for data. containing any reference to # N / A value of the cell will return # N / A.
The solution: wait for the data in the cell is filled with data.
6) error value: # NAME?
meaning: the formula used in Excel can not recognize the text, such as possible lose the wrong name, or enter a name deleted, if not the literal string enclosed in double quotes, will produce the error value
solution: If you are using a name that does not exist arising from such errors should be sure to use the name does exist; if the name, function name, spelling mistakes should be corrected; the text string enclosed in double quotes; sure all areas used in the formula are used in reference to a colon (: ). For example: SUM (C1: C10). Note that the formula in the text enclosed in double quotes.
7) error value: # NUM! meaning: to provide an invalid argument to the worksheet function, or is the result of the formula is too large or too small to be expressed in the worksheet.
solution: Make sure the function parameter type used is correct. If the result is too big or too small for the formula, we should modify the formula, it results in -1 × 10307 and between 1 × 10307.
8) error value: # NULL! meaning: in the formula to insert a space between the two areas to represent the intersection, but These two cells, there is no public. For example enter: . the style can be changed to to tell EXCEL to complete the action specified by the user. macro is similar to a computer program, but it is being completely run on EXCEL, we can use a macro to complete the tedious, often repetitive work. macro to complete the action faster than the user's own done much faster. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We also You can create a macro, in the do not know when to look for a macro to help. In fact, you may rest assured bold to use, if you only use the time, as long as the implementation of this macro, the system will put the operation and run it again.
macro given below applications, as long as the If you want the recorded macro and then edit it, we should have some knowledge of VBA.
* set a table for each job requires a fixed form of the header;
* set the cell has its own style into a form;
* are fixed for each print page setup;
* frequently or repeatedly enter some fixed content, such as Address lined form, list of other;
* create a formatted table;
* insert a thin sheet or other.
be noted that, EXCEL Macros and WORD macros some differences, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so in relation to the operation of position, be extra attention. If the phase by using relative references, can be Offset by means of methods, such as the following statement: ActiveCell.Offset (1,0). range (little, if you really use it, you will find it to have more content and more flexible application methods.
12, the chart application skills
Excel offers 14 standard chart types, each with a variety of combinations and transformations. Among the many chart types, select a chart that better? according to the different data and different requirements, you can choose different types of chart. The choice of the chart with the data in the form of relevant, then we consider the effectiveness and sense of aesthetics. Here are some common rules.
area chart: shows the magnitude of change over time. When Several parts are unchanged, while the sum of those parts you are interested, they are particularly useful. area chart that you see changes in the various parts separately, but also see the overall change.
bar: formed by a series of horizontal bars. makes a point on the timeline, two or more items is comparable relative size. For example: it can compare each quarter, any one of three products in the sales volume. Article charts in each of the worksheet is a single data point or more. because it is just the column of the rows and columns are transferred over, so are sometimes used interchangeably.
cylindrical Figure: composed by a series of vertical bars, usually a period of time to compare two or more items in the relative size. For example: quarterly or annual sales of different products compare several projects in different sectors in the funding allocation, each year The number of such types of information. bar chart type is used widely, many people are using the chart from its beginning.
Line: is used to show trends over time. For example: data over time is an increasing trend, and the other in a downward trend over time, we can line chart, to predict the future. For example: speed - time curve, thrust - fuel consumption curve, lift coefficient - Mach number curve pressure - temperature curve, the fatigue strength - rotation curve, the power costs of transfusion - transmission distance curve, using a line chart can be expressed more generally in engineering applications, if one of the data in several ways, line chart where there are several different lines, such as five athletes in the ten thousand meters the speed of the process of change, there are five line, compared to each other, can also add a trend line to predict the speed.
stock chart : It is with three data series line chart is used to display a given time period of the subject shares of high, low and close. by the highest, lowest drawing lines between data points forming vertical lines, while the axis representatives on the closing price of a small scale. stock chart used for finance, commerce, etc., used to describe commodity prices, currency exchange rates and the temperature, pressure measurement, of course, describe the stock price is the best at the.
pie chart: comparison of several data used for the formation of the sum of its percentage of the value of the most useful. the representative of the total pie, each with a wedge or slice the number of representatives. For example: total sales of different products that percentage of total sales, the units of the total funding for the proportion of funding, collection of books, how many of each type and so on. expressions pie chart although only one data column, but for expressing more clearly understood, but also easy to learn , and therefore in practice more than used. If you want multiple series of data, you can use the ring diagram.
radar: How to display data or other data changes at the center. each category coordinates from the center of radiation. from the same series of data lines connected with. You can use radar to map the sequence of several interrelated, it is easy to make a visual contrast. For example: You have three with five same parts of the machine, the radar can draw on each machine for each component wear.
XY scatter: show pairs of numbers and the trends they represent the relationship between . For each number on a number is drawn in the X axis, while the other was drawn in the Y axis. had two points in the vertical axis, intersecting at a mark on the chart. when a large number of such be drawn, the emergence of a graph. Scatter the important role of the function can be used to draw curves, from simple trigonometric, exponential, logarithmic functions to more complex hybrid function, can use it to draw quickly and accurately the curve, so in teaching, often used in scientific computing.
There are other types of charts, such as Cylinder, Cone, Pyramid, just a variation of bar and column charts with no outstanding features, but with a relatively small, this stop here. here is to note: This is only general application of the chart, sometimes a set of data can be used to express a variety of charts, then should be selected according to specific circumstances. For some charts, if a data sequence drawn into a cylinder, while the other is drawn into a line chart or area chart, the chart will look better.
in EXCE in L allows the creation of such a combination of charts, but if you want to create an EXCEL chart type combination is not allowed, such as a two-dimensional map can not be the same mix with a three-dimensional chart, this combination is not possible, the system will display an error message. how to build mixed-chart it? click the Do these forms are still not satisfied within the definition to click the
Of: ●. ●. Has been shared 4 times Comments (0) Copy this link to report Excel Advanced sharing tips
1. Editing skills
2. Unit cell contents of the combined
3. conditions indicate
4. custom format
5. Drawing Function Image
6. custom functions
7. Matrix
8. automatically switch input
9. batch delete empty lines
10. how to avoid the error message
11. macro use
12. icon application skills
1, editing skills
1 editing skills
(1) fraction of the input
If the direct input of January 5
(2) sequence quotation marks), then enter
(3) the date of the input
If you want to enter the If you want to enter the current date, click
(4) fill streak
workbook if you want to join in the beautiful horizontal stripes, can use the alignment of the filled function. First filled in a cell of
Figure 1
(5) multiple sheets to enter the same content in several worksheets
enter the same data in the same location, you can select a worksheet, and then hold down the Ctrl key, then click the window to the bottom left corner of the Sheet1, Sheet2 ...... to directly select the input the same content multiple sheets, then in any one of them to enter these same worksheet data, then the data will automatically appear in the table selected among other work. After input finished, press the Ctrl key on the keyboard, then use the left mouse button click on the selected multiple worksheets, work table to remove these links, or in a form input data will then appear in the election the other work table.
(6) cells do not continuously fill the same data
select a cell, hold down the Ctrl key, right click the other cells, it will select all those cells the. Enter data in the edit area, then hold down the Ctrl key while you tap Enter, in all the selected cells have emerged in the data.
(7) to display the formula in cell
data in the table if the majority of work is generated by a formula and want to quickly know the formula for each cell in the form of, for editing , you can do: Use the left mouse button click on At this time the division of labor in each cell that come. If you want to restore the display of calculated results to re-set
Figure 2
(8) Select the text using Ctrl + *
a work table, if there are many data tables, you can select the table by a cell, and then press Ctrl + * key to select the entire table. Ctrl + * the selected region: According to the selected cell to the surrounding radiation data involved are the largest regional cell. So that we can easily and accurately select the data table, and effective method to avoid dragging large range of cells selected screen Luangun phenomenon.
(9) quickly remove the contents of the cell
If you want to delete the contents of the cell content and its format and comments, can not simply be applied to the cell selected, then press the Delete key way to go. To completely remove the cells, using the following method: you want to remove the selected cell or range of cells; click the
2, the combined cell contents
needed, and sometimes want to B and C list the contents of the column to merge, if the number of rows less, can be directly with the
solution is: In the C line, insert a blank line (if the D column is not content to operate directly in the D column), in D1, enter , C, and the two columns. Select cell D1, the cell with the mouse to point the bottom right corner of the small box B series and C series combined. Then do not just put the first B and C column remove column, the first column of the results of D should copy it, and then Time you delete B, C, D columns.
The following is a With AutoCAD drawing, some people like the coordinate point is stored in EXCEL, called when drawing curves in these parameters. Stored data format is merged into C column, enter in C1: = A1 &All contents of the combined (see Figure 3-4).
merge the contents of different cells, there is a way is to use CONCATENATE function, the function of certain text string into a string, the specific operation for the . For example, assume that the investigation in a river ecosystem in the table, B2 contains ,
Figure 3 Figure 4
3, conditions indicate
we know, the use of If the function can be achieved in accordance with the conditions of display. A common example is when the teachers in student achievement statistics, want to enter scores below 60, can appear as This effect, the use of IF functions can be easily achieved. Assumption results in the A2 cell, determine the results in cell A3. Then in cell A3 enter the formula: = if (A2 <60,
For example, if you type: = if (A2 <60,
If you enter = if (A2 <60, to four grades.
another example, the formula: = if (SUM (A1: A5> 0, SUM (A1: A5), 0) this style on the use of a nested function, meaning that, when A1 to A5 and large at 0, returns this value if less than 0, it returns 0. Another point to draw your attention: The above symbols are the half-angle, and the IF with no spaces between brackets.
4,
Excel custom format by default in a lot of useful data formats, and can basically meet the requirements of use, but some special requirements, such as highlighted in some important data or information, set the display conditions, we must use a custom format function to complete. Excel custom format using the following general model: a positive number format, negative format, zero format, text format, in this general model, including three numbers and a text segment segment: use of data greater than zero positive number format; less than zero data using a negative format; zero data using a zero format; enter the body cells to use text format. We can also use test, add descriptive text and color to expand the use of custom format general application of the model.
(1) use of color in a custom format to a paragraph set the color, simply add the paragraph with enclosed in square brackets, color name or color number. Excel recognize the color is named: [black], [Red], [White], [Blue], [Green], [blue] and [magenta]. Excel is also recognition Press [Color X] specified color, where X is a number between 1-56, representing 56 kinds of colors (Figure 5).
Figure 5
(2) add description text After the input digital data to automatically add text, using a custom format: Excel numeric data input position relative to add text.
(3) create a conditional format to the six conditions of the logical symbols to design a format: ), > = The corresponding figures using the format specified in paragraph, paragraph 3 of the remaining numbers to use format. If the test contains only one condition, they have different situations according to specific analysis.
custom format of the generic model is equivalent to the following formula : [>; 0] is the number of formats; [<; 0] negative format; zero format; text format.
an example is given below: Select one, and then click the The #, # # 0.00); , will be displayed in the cell shows $#,## 0.00); [blue] color. If you enter br>
another example, assume that the ongoing settlement of accounts, you want to use the blue more than $ 50,000 account balance, negative values shown in brackets in red, the rest use the default value color display, you can create the following format: 0.00_) used in the preparation of the budget, need converted from grams kilograms, tons, then you can define the following format: _k_m
In addition, we can use a custom format to achieve the purpose of hiding the input data, such as the format Hide all the input values. custom format only changes the appearance of the display of the data, the data does not change the value, that does not affect the calculation of data. flexible use of a good custom format function, will give a great deal of practical work convenient.
5, drawing functions for teaching image
friends will encounter problems drawn function curve now! If you want to draw quickly and accurately a function curve, a chart can make use of EXCEL functions, it can make you draw the curve of both standard and beautiful. You have to ask, is not hard to learn it? fact, this is not difficult, can be very simple, do not believe you told me to try.
to draw the y = | lg (6 + x ^ 3) | of the curve, for example, the method is as follows: in a blank worksheet, enter the function of self- variables: A column in the cell A1 enter Arithmetic input method, enter the first two values, given the number of variables and the number from the step between, and then select the two cells A2 and A3, so that the two into a rectangle with a black border, and then This is a black rectangle with the mouse to point to the lower right corner of the small box input function type: B1 cells in column B enter the general functional form of written expression, y = | lg (6 + x ^ 3) |; in cell B2 enter the , B2 Genei Ma calculated on the results obtained. At this time, and then select cell B2, so that the cursor point to the lower right corner of the rectangle B2 place to complete the calculation of function values.
Figure 7
drawn curve: Click the toolbar 7), then in the Note: How to determine the initial value of the independent variables, the step between data points is the number, this is according to the specific characteristics to determine the function, which is the ability of the test users. If you want to function extremely quickly found value or see its development trend, the data presented do not necessarily have to be a point arithmetic, can be arbitrarily given.
from simple to complex logarithmic trigonometric functions, exponential functions, are EXCEL can be used to draw curves. If available, you can also use EXCEL to complete the determinant, the matrix of the various calculations, a simple integral operation, the use of iteration of a function value (such as x ^ 2 = x ^ 7 +4 , can be iterative method to solve x value), and so on, all things related to computing, to find EXCEL to help, it will give you a satisfactory answer.
6, Although the custom function
already a large number of built-in Excel function, but sometimes may also encounter some computational functions can be used without the case. If a company uses a special mathematical formula to calculate the discount products buyers If there is a function to calculate how much more convenient? said the following about how to create such a custom function.
custom functions, also called user-defined functions, Excel is the most innovative and attractive features one of the following Visual Basic we create a function module. In the following example, we give each person the amount by a factor, if it is working meals at work, and beat the tickets; if it is working overtime meal hit half of the amount; if it is a rest day to dinner, hit Jiuzhe. First, open the * tatol ElseIf rr = > Then close the editor, as long as we enter in the appropriate column rrr (F2, B2), then the amount of money even after the kick off out (Figure 10).
Figure 10
< / p>
7, Matrix
Excel's powerful computing capabilities, not only simple arithmetic, it can be an array, matrix calculations.
(1 ) the definition of arrays and matrices
matrix is not a number, but an array. In Excel, the array of domain occupied by a unit, the unit field with large brackets, such as {A1: C3}, in order and the general unit Domain A1: C3 phase difference. set the selected cell when the first field, press Shift + Ctrl + Enter key to automatically generate large parentheses, an array of fields to be confirmed.
a cell is a variable, a unit of the domain can be as a set of variables. In order to calculate the convenience, a set of variables to an array of the best name. For example A = {A1: C3}, B = {E1: G3} and so on. array name setup steps are: an array of fields selected , click the enter the name on the line.
matrix function is Excel-specific modules for matrix calculations. use the The calculate all the matrix elements corresponding to the product of the sum.
Figure 11
(2) the basic calculation of matrix computation and matrix array
very different calculations, such as the following example, A and B are defined array, as the two arrays are 3 × 3, the output is 3 × 3 unit cells. calculated results when the first output of the selected matrix domain of 3 × 3 of the range of cells, and then enter the formula. If you enter and . br> In a worksheet, the data is often both, there are text, so that input back and forth in the need to repeatedly switch between English and Chinese input method is very troublesome. If you want to enter something great regularity such as this column is all words, all Chinese to explain the next column, you can use the following method for automatic switching. is:
(1) Select the column to type in English, click Select the Click English automatically switch between input methods.
9, bulk delete blank lines
sometimes we need to delete Excel workbook in the blank line, the general practice is to eleven to find empty lines, and then delete it. If the number of rows in the table a lot of work, this is very inconvenient. We can use the Insert a new blank line, then press Ctrl + A keys to select the entire worksheet, right-click have suffered a drop-down list box, in a typical drop-down list box, select the column br> In all cases the data have been selected, click the Data one of the blank cells, while the other columns of data and blank cells are not affected, you can copy the first column, paste it to a blank worksheet, according to the above method to delete all blank lines, and then Copy this column and paste it into the original position of the corresponding worksheet.
10, how to avoid the error message
enter the formula in Excel, sometimes not correctly calculated results, and in the cell displays an error message, the production of these errors, some due to the formula itself, and some are not. Here's introduce some common error messages, and proposed ways to avoid mistakes.
1) :####
mean error value: Enter the data into a cell or cell formula is too long the result is too large, so that the results show no less than in the cell. Date and time format, or the cell subtraction, there has been negative.
solution: increase the width of the column so that the results can be fully displayed. If it is subtracted from the date or time had caused negative , you can change the format of the cell, such as to text format, the result is a negative amount of time.
2) error value: # DIV / 0!
meaning: trying to divide by 0 . This error is usually associated with the following situations: the divisor is 0, the divisor used in the formula or the empty cells contain a zero value cell reference cells.
solution: Modify the cell references , or used as a divisor input cell value is not zero.
3) error value: # VALUE!
meaning: the text-input mathematical formula item. If you use incorrect parameters or operator, or when performing an automatic correction function can not correct the formula for the formula, will produce an error message # VALUE!.
solution: At this time the formula or function should be required to confirm the operator or parameters correctly, and that a formula references a cell contains a valid value. For example, cell C4 has a numeric or logical values, cell D4 contains the text, then the formula = C4 + D4, the system can not convert the text to the correct data type, which returns the error value # VALUE!.
4) error value: # REF!
meaning: delete the formula referenced by the range of cells.
The solution: restore the referenced cell range, or re-set the reference range.
5) error value: # N / A
meaning: no information can be used to run the calculation. In modeling, the user can enter in a cell # N / A, to show that is waiting for data. containing any reference to # N / A value of the cell will return # N / A.
The solution: wait for the data in the cell is filled with data.
6) error value: # NAME?
meaning: the formula used in Excel can not recognize the text, such as possible lose the wrong name, or enter a name deleted, if not the literal string enclosed in double quotes, will produce the error value
solution: If you are using a name that does not exist arising from such errors should be sure to use the name does exist; if the name, function name, spelling mistakes should be corrected; the text string enclosed in double quotes; sure all areas used in the formula are used in reference to a colon (: ). For example: SUM (C1: C10). Note that the formula in the text enclosed in double quotes.
7) error value: # NUM! meaning: to provide an invalid argument to the worksheet function, or is the result of the formula is too large or too small to be expressed in the worksheet.
solution: Make sure the function parameter type used is correct. If the result is too big or too small for the formula, we should modify the formula, it results in -1 × 10307 and between 1 × 10307.
8) error value: # NULL! meaning: in the formula to insert a space between the two areas to represent the intersection, but These two cells, there is no public. For example enter: . the style can be changed to to tell EXCEL to complete the action specified by the user. macro is similar to a computer program, but it is being completely run on EXCEL, we can use a macro to complete the tedious, often repetitive work. macro to complete the action faster than the user's own done much faster. For example, we can create a macro for each row of the worksheet, enter a date and in each cell within the center-aligned date and format of this border-line application. We also You can create a macro, in the do not know when to look for a macro to help. In fact, you may rest assured bold to use, if you only use the time, as long as the implementation of this macro, the system will put the operation and run it again.
macro given below applications, as long as the If you want the recorded macro and then edit it, we should have some knowledge of VBA.
* set a table for each job requires a fixed form of the header;
* set the cell has its own style into a form;
* are fixed for each print page setup;
* frequently or repeatedly enter some fixed content, such as Address lined form, list of other;
* create a formatted table;
* insert a thin sheet or other.
be noted that, EXCEL Macros and WORD macros some differences, for the recording operation, it will remember the coordinates of the cell (ie, all references are absolute), so in relation to the operation of position, be extra attention. If the phase by using relative references, can be Offset by means of methods, such as the following statement: ActiveCell.Offset (1,0). range (little, if you really use it, you will find it to have more content and more flexible application methods.
12, the chart application skills
Excel offers 14 standard chart types, each with a variety of combinations and transformations. Among the many chart types, select a chart that better? according to the different data and different requirements, you can choose different types of chart. The choice of the chart with the data in the form of relevant, then we consider the effectiveness and sense of aesthetics. Here are some common rules.
area chart: shows the magnitude of change over time. When Several parts are unchanged, while the sum of those parts you are interested, they are particularly useful. area chart that you see changes in the various parts separately, but also see the overall change.
bar: formed by a series of horizontal bars. makes a point on the timeline, two or more items is comparable relative size. For example: it can compare each quarter, any one of three products in the sales volume. Article charts in each of the worksheet is a single data point or more. because it is just the column of the rows and columns are transferred over, so are sometimes used interchangeably.
cylindrical Figure: composed by a series of vertical bars, usually a period of time to compare two or more items in the relative size. For example: quarterly or annual sales of different products compare several projects in different sectors in the funding allocation, each year The number of such types of information. bar chart type is used widely, many people are using the chart from its beginning.
Line: is used to show trends over time. For example: data over time is an increasing trend, and the other in a downward trend over time, we can line chart, to predict the future. For example: speed - time curve, thrust - fuel consumption curve, lift coefficient - Mach number curve pressure - temperature curve, the fatigue strength - rotation curve, the power costs of transfusion - transmission distance curve, using a line chart can be expressed more generally in engineering applications, if one of the data in several ways, line chart where there are several different lines, such as five athletes in the ten thousand meters the speed of the process of change, there are five line, compared to each other, can also add a trend line to predict the speed.
stock chart : It is with three data series line chart is used to display a given time period of the subject shares of high, low and close. by the highest, lowest drawing lines between data points forming vertical lines, while the axis representatives on the closing price of a small scale. stock chart used for finance, commerce, etc., used to describe commodity prices, currency exchange rates and the temperature, pressure measurement, of course, describe the stock price is the best at the.
pie chart: comparison of several data used for the formation of the sum of its percentage of the value of the most useful. the representative of the total pie, each with a wedge or slice the number of representatives. For example: total sales of different products that percentage of total sales, the units of the total funding for the proportion of funding, collection of books, how many of each type and so on. expressions pie chart although only one data column, but for expressing more clearly understood, but also easy to learn , and therefore in practice more than used. If you want multiple series of data, you can use the ring diagram.
radar: How to display data or other data changes at the center. each category coordinates from the center of radiation. from the same series of data lines connected with. You can use radar to map the sequence of several interrelated, it is easy to make a visual contrast. For example: You have three with five same parts of the machine, the radar can draw on each machine for each component wear.
XY scatter: show pairs of numbers and the trends they represent the relationship between . For each number on a number is drawn in the X axis, while the other was drawn in the Y axis. had two points in the vertical axis, intersecting at a mark on the chart. when a large number of such be drawn, the emergence of a graph. Scatter the important role of the function can be used to draw curves, from simple trigonometric, exponential, logarithmic functions to more complex hybrid function, can use it to draw quickly and accurately the curve, so in teaching, often used in scientific computing.
There are other types of charts, such as Cylinder, Cone, Pyramid, just a variation of bar and column charts with no outstanding features, but with a relatively small, this stop here. here is to note: This is only general application of the chart, sometimes a set of data can be used to express a variety of charts, then should be selected according to specific circumstances. For some charts, if a data sequence drawn into a cylinder, while the other is drawn into a line chart or area chart, the chart will look better.
in EXCE in L allows the creation of such a combination of charts, but if you want to create an EXCEL chart type combination is not allowed, such as a two-dimensional map can not be the same mix with a three-dimensional chart, this combination is not possible, the system will display an error message. how to build mixed-chart it? click the Do these forms are still not satisfied within the definition to click the
Monday, May 16, 2011
Lost mobile phone
Ginza shopping yesterday when the phone is lost
a younger brother finally took a phone call
today have nothing but an easy
Today is the birthday of his younger brother
morning called and he seemed very busy
to call back at night
busy today, home phone , but bad
Oh
thought I disappeared of it
I've been 24 hours a day of it
lost cell phone number hurt distressed
old friends , quickly contact me
otherwise I really want to lose you can be friends
a younger brother finally took a phone call
today have nothing but an easy
Today is the birthday of his younger brother
morning called and he seemed very busy
to call back at night
busy today, home phone , but bad
Oh
thought I disappeared of it
I've been 24 hours a day of it
lost cell phone number hurt distressed
old friends , quickly contact me
otherwise I really want to lose you can be friends
Subscribe to:
Comments (Atom)