Manjusri (the Constitution leaves to the left Meng Nan Jing Gangshan)
.. actually the second woman to play
to find a third wanted to let you know stylist Buddhism originated in India, long as Hill Gang Gang Mountain ah .. .. .. mustache
India Asan is to force another style reminds me of the Gods in The King Zhou
Yumian Princess (Zheng Yiping Wang Yi Qinzi more)
This is the first primary three temperament, a child that Yumian fox so pretty dead. The little children look really hook people.
Second third where it acceptable
Yumian it? Princess is obviously a black face, long beautiful yet ward. .. Cow to go off for the hair to new flavors, you cow?
Tota Lee King (Wang Yuli Eddie Kwan Yi Zhao)
Silver Bronze Saint Seiya Saint Seiya Gold Saint Seiya
daughter of the country Taishi
Which is the third Taishi. Clearly that Shi Tai. . . .
wow. . .
Chang (Qiupei Ning Liu Ying Wang Hui)
first came to earth from heaven as the
second is very beautiful, but too few Xianqi
as the third heaven and earth come from. But she very pretty.
blue bull sperm.
plainer black
age of six small children to be like this
bear brown bear blame (items Han Zhou Jiwei?)
The second, like wild boar sperm
sure the old World of Warcraft third makeup artist, modeling Haobang, For the Horde! You know the ~
wrong to cut shots, as Mao was
Taibaijinxing (Wang Zhongxin Shi Yu Yang Niansheng)
really figure who trained in the old version, the back and maybe has, it is the land where the third
more than one look like a Chinese characteristics, ah ... Xianqi children do what the Secretary went to the
Erlang (Feng Shao Feng Xiao-Tian Lin Zhiqian India)
the first two so the block on the third eye? How do I know that you are Erlang, or whooping days?
No. 3 is Riboud
read the third, finally solved the puzzle has been to understand Mao turned to Dragon for the embrace of nine insects CCTV distort the original
funny ah do love triangle out when you have reason to go see the original of this is before the Little White Dragon Ma
original did not say he is handsome in all Nothing looks description
brawny - Pig mane just the embodiment (Madrid Huamiao Hai Zhong Zang Jinsheng)
1 warrior 2, 3 butcher
small two first Ma Dehua really cool! Meng ~ see maybe has a very small dimple
ignore it
the second or third Zang Jinsheng Lu Zhishen play it, the Water Margin in the Zang Jinsheng more handsome ah. Which can be considered to destroy. Look bad phase
Princess Iron Fan.
you do Arab from Arabia it. Or the Arab it? Fashion version of Afghan women
second. Your eyes that ecstasy was. The third gold silver angle changed to upgrade the king.
fine spirits (Li Jiancheng Yan Youting Qiang)
First Look eye to fine
s Anime COSPLAY
two third of the stylist is clever you eat more beans? That is scary monsters did not need to continue to ah .. Warcraft
Dianmu (? Guojin Ying Zhang Chunyan)
second chest also put a sign of lightning, for fear that others do not know. But actors get pretty long.
third brain power on the plug hair ~ make-up artist returned home to Japan to study a good hair do not give the actors? ? ?
seven spider sperm shower photo
The first one is 7 Zhizhu Jing bath
The second is the seven spiders bath
third is seven non-mainstream child a bath .....
Zhizhu Jing feel this most classic of the bath. 2 results like the Hot Springs Resort. Version 3 something that is a bunch of Shima
colorful head ah you want to do Shima? ? ~ ~ Lao Zhu should be ~ ~ do not like the same! !
nine fox (age six small children Feng Xiaoqin?)
1 Chen Handian (like, right? Oh, age is six small children)
2 matchmaker
3 did not find her face
Zhang Jizhong version of World of Warcraft.
Red Child (Zhaoxin Pei Meng Yansen Nga Ning)
first an old version of Red Boy is too good .. looking good Meng wanted Pinch up the eyes of the second face
too communist, and quite similar to Pan Dongzi, Little Soldier?
third Taibuyinggai, and you have to bring cattle genes
Po as the King (Gu Lan Sheng-Rong Li TERM)
third hair was ecstasy, ah, how I said it so familiar. Spade king .. getting a sideline to roast a lamb skewers Han. Important chili child does not?
King of the Golden Horn (car Xiaotong Sun Qiang?)
first one is 24K gold forehead. New version of the forehead did not even have jewelry in a second
, you are sheep? Brain tumors have a long head on the
the third king of the Golden Horn is not this cargo, which cargo is carved ~
two version of King of the Golden Horn and Yazhaifuren kissing his wife said: king, can you grind the tip of the nose a little, good bar-oh ~
the first and the third the little eyes, looking like the evil of the fairies < br> The second I do not spade, and your chest close to that huge a scorpion, afraid of people do not know you monster? Is obviously a scorpion on his head like a spider but inserted
, even served ~
old reality - the embodiment of the Monkey King (children age six small fee Xiang Wu Zhen Yue)
six brother really did not say, look at this little eyes seemed to sell
Zhejiang Shi Sanxiang version of the ...
s Two little 卡哇伊 nose. The third white beard cattle grandfather. . .
Thunder (? Zhou Zhong Li Dan)
black red, the first circuit instability ah
not say. The second class
handsome Ray Baba Steel Company to pull his head on the third Thunder
chicken does not mean the public right, public and also their chicken turkey burning into public This is also the implantation of KFC ads? Good
it. Well, I admit that you are Thunder. Die of me. Killing me. Me. The
Skeleton Demon.
really Skeleton Demon. People also took the bones of the pinch. The first is the true artist in the show, the latter two is not bad
three spider woman (Du Xianghui Xuejia Wen Fei Yan Pan)
the second edition of the spider woman Zhejiang is a haircut for the hair ah? 7 births ah 7 births
third dedicated you, please? Can you bring out the point of occupational characteristics? Is a large fashion it? ? ?
six spider woman (Lvhai Yu Jiang Fei Yan Wang translated Mo)
second is fine *** Lang shell, always keep in mind a ball of dung.
third go bohemian Zhizhu Jing
Yang Liu Guan Yin (Joan Chen Zuo Bin Liu Tao)
This is the first in my mind after the two do not want to Guanyin
evaluated. Temperament did not like urban-rural integration
Xianqi third is beautiful. Is not Buddha. In one.
seven female spider (Liulin Qiu Ye Zhang Lisha)
1 Elf
2 nuns
3 country girl.
you are too much a third of the bar. I do not believe this is the unspoken rules come up. Two version of the Pig is her to play it? . . . Seven pigs sister
us (Ai Jinmei Luoyong Juan Ma Rui Hao / Ma Rui Han)
an old version of us is the first Red Army < br> The second was good. Beautiful and proud, but also the temperament
Qingxia third sister is sprouting
two spider woman (Liu Qianyan Master?) < br>
the first actress that age is really a natural beauty. Awl is not popular now face. .
have to second the top of a spider on his head - - ~
third is the monster it? Ah was good and decent woman!
saying that version 3 is actually all came pretty long
twenty-eight stars of Kuimu Lang (?? Chenghao Feng)
you the second your sister again?
third comb your hair, you you you do not come out fitted ghost scary
Fish Basket Goddess of Mercy (Joan Chen Liang Zuo Bin)
The first is the true Buddha body. The second is not too small to explain
gas to market to buy a la carte home from work Yaki-Yaki. How can a little Buddha
third appearance
high Turquoise Blue (Weihui Li Cao Xi Wen Mo Xiaofeng)
3rd good brothel, a dust gas, Gao lady was no decent women it? Looks like the eyes of dysmenorrhea in contempt directed awl gorgeous face you killed the me me me die right
Lao Zi ( Zheng Rong Fan Zhiqi Zhang Jizhong)
third or two does not explain
Zhang crew guide your guest from the Gods come it? Director Zhang
stir together you do not follow the. Lord Lao Zi did not you so fat. .
fish! ! ! ~ ~ Red fruit fruit of the fish. . . .
flaming land (Li Shuang Ji by Wang Chao plot)
second is Nicky Wu it?
third dwarf + lm + Wu Dalang Chuibing + priest .. +***... Zhang Jizhong also play World of Warcraft amount of it? There were questions about why two are disheveled version of Immortality, the gods do not need to comb it?
the first two together, mocking the third ... ...
Heiwu Chang (?? Hushao Long)
third Hei Wuchang good international ..
Montenegro witch + Voldemort + death + Hodak + Skeleton King + Death Eaters Dementors + + dead + Lich
Juling Shen (Qian Jia Kang CG Computer stone)
second .. CG
the third heaven Uniforms do not send it?
Buddha Ji Ling (Singapore Renxue Hai Feng Ren Su Mao)
the first second which is not explained
Secretary for the photo shoot, just fat
to offside if they visit the third make-up artist in the jerry can you point it? ? Golf ball on his head it? Even if the Buddha compared it to both men and women does not mean androgynous ah. Has clearly been too evil spirits Jianpu. How can a little solemn
Po phase is so blasphemous retribution ....< br>
apricot cents (Zhou Rui Li Hua Wang Ling An)
the first best, this is consistent with the image of fairies in my heart. Still remember the way she was dancing. . U.S. second one died
dust gas
third ah, you asked me what to say, wearing an apricot almond and apricot cents to really up? If the watermelon cents a watermelon head would have top it?
canopy Marshal (Madrid Huamiao Hai Zhong Zang Jinsheng)
second salty paste. Oh ~ Zang Jinsheng third
be ruined, does the canopy Marshal with Niu Gur also related. Hair comb my hair out for the two corner ah? ? To non-words that I can only say as you like, or Zhang Fei Li Kui
Bai Wuchang (?? So high)
second The third one was already scared
third. Quickly identify the west of the roll back. . . . ! !
pig just Iguana (Madrid Huaxie Ning Zang Jinsheng)
second is a pig nose and pulled the third steel
boar bristles tribal people! ! Good wave hair! ! Chao pig! ! Is the most popular flowers round head, oh. This year a lot of stars have comb Oh. Implantation is this ad? Flowing hair ... that is so confident with the Rejoice • •
saying that you SARFT discord. What do the Friends of terrified Xiaopen ..
Halloween Dragon King (Zhao Bao before??)
Do not know the names of the latter two worth mentioning, known also not be reached. .
Big Night Elf Druid is only the third, the Greek mythology and ancient Chinese mythology clever combination of old Neptune Orient Dragon King Temple Poseidon and a perfect fit million total that killed The third will fall like a small gourmet equipment, the hands of the big windmill ah .. la la la la leisurely turn
hair female (? von Jiao Hong Zilin)
third nuns shape, YY YY head and mouth, Shuangwai Wai spokesperson, also of wood with the upper lip
< br>
Zang (Xu Shaohua Victor Chen Nie Yuan)
The first is Xuanzang
The second is to return to secular life (in fact, still handsome)
third is the monks. Lu Zhishen. And sea. . . .
simply do not learn from the third train an apprentice monk himself went on the road can destroy the evil forces of several organizations ~ ~ too sturdy a ~ ~
one hundred angel
the first look of evil is evil the second you so righteous
awe-inspiring how Yanhuai Ren?
third Xuzhi Sen uncle who broke your heart drop Yo ..
Left: CCTV in the 1986/1998 edition of the Monkey King
: Zhejiang Yongle 2009 edition of the monkey
right: two monkeys in the 2010 edition of the monkey
(children age six small fee Zhen Xiang Wu Yue)
screen: the first two Monkey King to see the monster a ~ < br>
Third Avatar. . . . . Shrek. . . . Voldemort. ?
Tripmaster Monkey
not everyone can be called the Monkey King! ! !
second barely.
third variants and cargo are radiation!
the Five Elements Mountain
first six small family of young children born in the opera, acted in several generations of their jaws, how can some people thought it would be scratching your head when the Monkey King .
Zhejiang Yongle 2009 version looks so beautiful as art, O death, are not mentoring with Guangyao Zi. Gorgeous paper umbrella ...
Zhang Jizhong the 2010 edition of this is simply the animal world.
CCTV. 1986. Which department do to shake his position. Classic picture ah.
This post has been edited on the 2010-09-26 11:22:08
Monday, April 25, 2011
Inventory of China's top ten
guide words: in all walks of life, some related to people's health, some related to mental outlook, showing that is vital; have friends summed up the current domestic industries, we have to see if Kaopu?
1, the tobacco industry
the industry is one of the few to the detriment of people's health as the main objective of the industry, in addition to pay a lot of tax revenue and to resolve problems of employment other than basically no longer necessary. Of course, smoking can relieve stress, pleasant spirit, but the consequences are too harsh, if the terminal illness and death of people to talk about the spirit of joy? And other unscrupulous industry is different is that employees in the industry does not exist in a very serious moral failure on any (except for some corruption problems), just doing a job it is hereby name the.
2, health products industry
hormone bought from abroad, brought back a watered down, and then spend lots of money to do vulgar advertising, then the price by several times to the second and third class cities and rural areas of a sell. This is typical of health care products in China. This is calculated in the health products industry, more civilized, because at least no what to put something poisonous, eating is the most excited about, a little early! Health care products industry's slogan is As long as you have the courage to have money, you can put a junk bigger and stronger! Then sounding name: the things we are eating dead people! Most useless hymns! Full range of advertising bombardment, how to how vulgar, the market space all to fill, there is no room for development of small businesses, even a very good product.
3, the stock investment industry
through this financial turmoil, the industry, Because it is the most direct dealings with the money the industry, it is also the most typical mercenary industry. This industry is full of up and down the idea of money first, unethical use the word is not appropriate here, because they never address the problem. Facts have already proved that making the rich mythology of the industry's most in other people (including medium and small shareholders) over the pain. Stock value investment philosophy is difficult to set up, Glossy coat of the industry and favorable income attracted countless top talent in droves, but almost without exception, have been money assimilation, stoop! Look at those pundits, as well as investment bankers in line, which is not the top students graduating from prestigious universities? But the higher the degree deceptive stronger, the more severe consequences. The money too fast, their personality and moral standards too low, employees in the industry is extremely corrupt life style, all day long dream life, light as a feather
4, the real estate industry
the industry and the tobacco industry on the contrary, there is nothing unethical industry itself is said, mainly employees of the moral failure is very powerful. The quality of employees in this industry from top to bottom the difference between the low-grade, for all to see! Have been adjusted for the real estate industry hope that the industry can look good and enhance self-examination, but the market is a little warmer they could not wait to jump out, prices, and shoddy work, false selling, the sales ladies looked down upon ... ... are as before. Always heard that capacity.
5, the entertainment industry
many practitioners of the characteristics of the industry are In this circle of They play relaxing drugs is a common means High. In the Based on its industry characteristics, easily become the public interest, especially the young people concerned, for the majority of young people set a very bad example! Over the years, the aura of entertainment attracted many families to spend countless efforts to cultivate children, hopes to become a star, only to become the This world is like a big fire pit covered with flowers, flowers attract many people were jumping down, burnt bones are not left.
6, the food industry
because I have a brand personality cult insist on drinking milk for years, I do not know how much they drank melamine into the belly! Event just happened when I was very sad, insisting that the top executives of these enterprises are also innocent victims, and then I even fool them in this circle are aware of melamine. This is just a microcosm of the food industry unethical, as long as the immediate supervision of the local people would not play tricks on how many toxins we eat every day, simply can not be calculated! Like vegetables and fruits such as overall supervision of the food is very difficult. Saw just one example: I once went to the countryside to play, to see one kind of green onions in the fields, the fields of a farmer is down to a dilution of the highly toxic pesticides (like dichlorvos), I asked him to do it? He said that a long thick green onions make good-looking, an acre of land to touch a few bottles. I asked this onion farmer pesticide residue on the body is not right? Farmer'd I stared at the green fields, do not know what to say, finally understand why the cancer is now common.
7, the pharmaceutical industry
pharmaceutical industry in China is the world's a great spectacle! First, many new drugs, and second, many pharmaceutical companies, these two are the highest in the world! That our R & D capability the world's strongest you believe it? Dr. abroad more than just the top people in it be possible to enter the pharmaceutical research and development, our pharmaceutical R & D capability is quite lacking. Important sales of drugs through advertising and rebates way to buy a doctor. So many new drugs, the main source is the trade-in, but also heard of taking the medicine to the foreign patent invalid country. This approach on the premise that collusion Food and Drug Administration, who was shot in the Food and Drug Administration Zheng also granted tenure to tens of thousands of new drugs, when one of the most reckless for the grant of the tens of thousands a year. Later, according to insiders, who recalls that the grand occasion is amazing: filled poly Drug Registration Department who give money, give money as long as the new drug through the approval of three minutes, so that the toilet was foreign counterparts as a joke to chat! In fact, the lack of new drug development capabilities it when, if we can stop and to what our ancestors left behind a good bit of research and development may also bring great economic and social benefits, such as Tong Ren Tang has been enduring! There are so many people the secret recipe, if pharmaceutical companies can make good use of our fathers left a precious legacy of Chinese medicine have saved, Chinese medicine has already embarked on the world! So that our pharmaceutical companies to enter the virtuous cycle that has been economic, but also for the benefit of the community, why not?
8, the medical industry
Chinese medical industry was mixed, immoral! XX from the scammers to commit employees have all kinds of popular cheat Hospital, Yituo popular and widely publicized by the media deceive patients. A few hundred dollars a cold black that you be kind, and nothing about them are often able to hit the newspapers. Arbitrary charges indiscriminately drug phenomenon has received red envelopes are the main means of income generation and universal truth. A friend of the top three hospitals in Northeast surgery a well-known hospital, go in the same room patients are kindly reminded that all costs must be compared one by one carefully, and to a particular row when the trouble must be possible to put the money back. My friend started also suspect that this is the top three hospitals will not openly bullying you? Later found out that if patients really works wonders. Almost every kind have been spent on a variety of strange with the extra overhead. My friend was a one to trouble them, but also to the big trouble with people. Finally found the cost of surgery, because it is unconscious, do not know how much was in the end with a bandage, how much blood lost, only to give up. Finally, the hospital was afraid of trouble, nearly half of the cost of actually back!
9, the coal mining industry (mainly private)
This is a very An example here to explain Shanxi coal bosses. The composition of some private coal mines are as follows: coal boss hired thugs, who died in addition to the accident immediately buried. Most of the coal owner owned several palaces in Beijing, a bus to take a day to day cash income remitted abroad in Beijing and then to hide or to ensure that basic bank account is not mine, Do so mainly in order to prevent coal mine accident at any time at running, and do not lose money. Because many do not know how to spend the money, and taste is definitely top five, and to buy luxury cars at the show is certain, is to buy a house in Beijing certain, and a buy a lot of sets. I have heard that there is a villa once Shanxi coal bosses bought 8 sets a more than ten million of the villa, and give to relatives and cowboys live, the last set is unoccupied, give their dog live. They would rather buy a house to spend a more than ten million dogs live, do not want to spend a penny to add some safety equipment to the miners to buy insurance! For such people, but also talk about morality? It is no opening to say: these people have earned every penny covered with blood and sweat of miners! Is that these people can be real estate developers in Beijing's favorite. Do not know when the money in a few developers will think about the above blood and sweat of miners? Would not think of these as part of the money donated to the miners to buy insurance? Really unjust, lighter than a feather!
10, the education sector
the education sector are listed here I am very sad, very sad! Was the Education and industrialization of money is the biggest source! Because of money, our beloved school teachers as well as to the vertical velocity of falling bodies fell from the sky directly to the ground, went straight to hell away. Studies have shown a healthy growth of the soul, only with his family and teachers have the primary relationship. But our teachers and schools have done what? Kindergarten teachers will not give gifts to their children because there is no little red; primary school teacher gifts and public humiliation because there is no child; school enrollment rate for all physical education and extracurricular activities were canceled, one by one train, Test Machine Mathematical Olympiad as the soul of this child abuse, personality ugly thing, but also because of pecuniary interests are released with great fanfare, harmed many children. If the unscrupulous food industry is damaging the health of people, then the education sector is the damage to people's unscrupulous character and soul healthy. If there is damage to the body if the hospital can be treated, the soul of health damage to hopeless! The reason I put education first in the industry listed in the wicked, because it not only destroyed the youth of this generation, but also ruined the future of China! Pillars of the country's future all finished, the country's future, what hope do? Lack of moral education industry, destroy families hope for the future and shake the foundation of the country's future, is the most immoral act! Light as a feather! Friends hope the majority of teachers thought. Of course, there are still many in the industry-respected teacher who has stood their ground and not moved by external temptations, indeed, worthy of respect!
the Editor: If the unscrupulous food industry is damaging the health of people, then the education sector is the damage to people's unscrupulous character and soul healthy. If there is damage to the body if the hospital can be treated, the soul of health damage to hopeless!
1, the tobacco industry
the industry is one of the few to the detriment of people's health as the main objective of the industry, in addition to pay a lot of tax revenue and to resolve problems of employment other than basically no longer necessary. Of course, smoking can relieve stress, pleasant spirit, but the consequences are too harsh, if the terminal illness and death of people to talk about the spirit of joy? And other unscrupulous industry is different is that employees in the industry does not exist in a very serious moral failure on any (except for some corruption problems), just doing a job it is hereby name the.
2, health products industry
hormone bought from abroad, brought back a watered down, and then spend lots of money to do vulgar advertising, then the price by several times to the second and third class cities and rural areas of a sell. This is typical of health care products in China. This is calculated in the health products industry, more civilized, because at least no what to put something poisonous, eating is the most excited about, a little early! Health care products industry's slogan is As long as you have the courage to have money, you can put a junk bigger and stronger! Then sounding name: the things we are eating dead people! Most useless hymns! Full range of advertising bombardment, how to how vulgar, the market space all to fill, there is no room for development of small businesses, even a very good product.
3, the stock investment industry
through this financial turmoil, the industry, Because it is the most direct dealings with the money the industry, it is also the most typical mercenary industry. This industry is full of up and down the idea of money first, unethical use the word is not appropriate here, because they never address the problem. Facts have already proved that making the rich mythology of the industry's most in other people (including medium and small shareholders) over the pain. Stock value investment philosophy is difficult to set up, Glossy coat of the industry and favorable income attracted countless top talent in droves, but almost without exception, have been money assimilation, stoop! Look at those pundits, as well as investment bankers in line, which is not the top students graduating from prestigious universities? But the higher the degree deceptive stronger, the more severe consequences. The money too fast, their personality and moral standards too low, employees in the industry is extremely corrupt life style, all day long dream life, light as a feather
4, the real estate industry
the industry and the tobacco industry on the contrary, there is nothing unethical industry itself is said, mainly employees of the moral failure is very powerful. The quality of employees in this industry from top to bottom the difference between the low-grade, for all to see! Have been adjusted for the real estate industry hope that the industry can look good and enhance self-examination, but the market is a little warmer they could not wait to jump out, prices, and shoddy work, false selling, the sales ladies looked down upon ... ... are as before. Always heard that capacity.
5, the entertainment industry
many practitioners of the characteristics of the industry are In this circle of They play relaxing drugs is a common means High. In the Based on its industry characteristics, easily become the public interest, especially the young people concerned, for the majority of young people set a very bad example! Over the years, the aura of entertainment attracted many families to spend countless efforts to cultivate children, hopes to become a star, only to become the This world is like a big fire pit covered with flowers, flowers attract many people were jumping down, burnt bones are not left.
6, the food industry
because I have a brand personality cult insist on drinking milk for years, I do not know how much they drank melamine into the belly! Event just happened when I was very sad, insisting that the top executives of these enterprises are also innocent victims, and then I even fool them in this circle are aware of melamine. This is just a microcosm of the food industry unethical, as long as the immediate supervision of the local people would not play tricks on how many toxins we eat every day, simply can not be calculated! Like vegetables and fruits such as overall supervision of the food is very difficult. Saw just one example: I once went to the countryside to play, to see one kind of green onions in the fields, the fields of a farmer is down to a dilution of the highly toxic pesticides (like dichlorvos), I asked him to do it? He said that a long thick green onions make good-looking, an acre of land to touch a few bottles. I asked this onion farmer pesticide residue on the body is not right? Farmer'd I stared at the green fields, do not know what to say, finally understand why the cancer is now common.
7, the pharmaceutical industry
pharmaceutical industry in China is the world's a great spectacle! First, many new drugs, and second, many pharmaceutical companies, these two are the highest in the world! That our R & D capability the world's strongest you believe it? Dr. abroad more than just the top people in it be possible to enter the pharmaceutical research and development, our pharmaceutical R & D capability is quite lacking. Important sales of drugs through advertising and rebates way to buy a doctor. So many new drugs, the main source is the trade-in, but also heard of taking the medicine to the foreign patent invalid country. This approach on the premise that collusion Food and Drug Administration, who was shot in the Food and Drug Administration Zheng also granted tenure to tens of thousands of new drugs, when one of the most reckless for the grant of the tens of thousands a year. Later, according to insiders, who recalls that the grand occasion is amazing: filled poly Drug Registration Department who give money, give money as long as the new drug through the approval of three minutes, so that the toilet was foreign counterparts as a joke to chat! In fact, the lack of new drug development capabilities it when, if we can stop and to what our ancestors left behind a good bit of research and development may also bring great economic and social benefits, such as Tong Ren Tang has been enduring! There are so many people the secret recipe, if pharmaceutical companies can make good use of our fathers left a precious legacy of Chinese medicine have saved, Chinese medicine has already embarked on the world! So that our pharmaceutical companies to enter the virtuous cycle that has been economic, but also for the benefit of the community, why not?
8, the medical industry
Chinese medical industry was mixed, immoral! XX from the scammers to commit employees have all kinds of popular cheat Hospital, Yituo popular and widely publicized by the media deceive patients. A few hundred dollars a cold black that you be kind, and nothing about them are often able to hit the newspapers. Arbitrary charges indiscriminately drug phenomenon has received red envelopes are the main means of income generation and universal truth. A friend of the top three hospitals in Northeast surgery a well-known hospital, go in the same room patients are kindly reminded that all costs must be compared one by one carefully, and to a particular row when the trouble must be possible to put the money back. My friend started also suspect that this is the top three hospitals will not openly bullying you? Later found out that if patients really works wonders. Almost every kind have been spent on a variety of strange with the extra overhead. My friend was a one to trouble them, but also to the big trouble with people. Finally found the cost of surgery, because it is unconscious, do not know how much was in the end with a bandage, how much blood lost, only to give up. Finally, the hospital was afraid of trouble, nearly half of the cost of actually back!
9, the coal mining industry (mainly private)
This is a very An example here to explain Shanxi coal bosses. The composition of some private coal mines are as follows: coal boss hired thugs, who died in addition to the accident immediately buried. Most of the coal owner owned several palaces in Beijing, a bus to take a day to day cash income remitted abroad in Beijing and then to hide or to ensure that basic bank account is not mine, Do so mainly in order to prevent coal mine accident at any time at running, and do not lose money. Because many do not know how to spend the money, and taste is definitely top five, and to buy luxury cars at the show is certain, is to buy a house in Beijing certain, and a buy a lot of sets. I have heard that there is a villa once Shanxi coal bosses bought 8 sets a more than ten million of the villa, and give to relatives and cowboys live, the last set is unoccupied, give their dog live. They would rather buy a house to spend a more than ten million dogs live, do not want to spend a penny to add some safety equipment to the miners to buy insurance! For such people, but also talk about morality? It is no opening to say: these people have earned every penny covered with blood and sweat of miners! Is that these people can be real estate developers in Beijing's favorite. Do not know when the money in a few developers will think about the above blood and sweat of miners? Would not think of these as part of the money donated to the miners to buy insurance? Really unjust, lighter than a feather!
10, the education sector
the education sector are listed here I am very sad, very sad! Was the Education and industrialization of money is the biggest source! Because of money, our beloved school teachers as well as to the vertical velocity of falling bodies fell from the sky directly to the ground, went straight to hell away. Studies have shown a healthy growth of the soul, only with his family and teachers have the primary relationship. But our teachers and schools have done what? Kindergarten teachers will not give gifts to their children because there is no little red; primary school teacher gifts and public humiliation because there is no child; school enrollment rate for all physical education and extracurricular activities were canceled, one by one train, Test Machine Mathematical Olympiad as the soul of this child abuse, personality ugly thing, but also because of pecuniary interests are released with great fanfare, harmed many children. If the unscrupulous food industry is damaging the health of people, then the education sector is the damage to people's unscrupulous character and soul healthy. If there is damage to the body if the hospital can be treated, the soul of health damage to hopeless! The reason I put education first in the industry listed in the wicked, because it not only destroyed the youth of this generation, but also ruined the future of China! Pillars of the country's future all finished, the country's future, what hope do? Lack of moral education industry, destroy families hope for the future and shake the foundation of the country's future, is the most immoral act! Light as a feather! Friends hope the majority of teachers thought. Of course, there are still many in the industry-respected teacher who has stood their ground and not moved by external temptations, indeed, worthy of respect!
the Editor: If the unscrupulous food industry is damaging the health of people, then the education sector is the damage to people's unscrupulous character and soul healthy. If there is damage to the body if the hospital can be treated, the soul of health damage to hopeless!
Sunday, April 24, 2011
Lightning fast turn around
morning to get up , still massaging the navel , beating with a pulse , chiropractic , but I did not put their ideas are concentrated in my hands , it could effect to be less convincing , MO suddenly turned around a bit , then it is less than the Thunder The trend has turned their ears back , my mother, who had been barking before and MO group will not stand up , now slightly, my stupid MO ~
Do not turn your loss Oh!
to the skin, and put dates porridge.
To not sleep, porridge Tim White Lotus.
backache kidney qi deficiency, put chestnut porridge.
guilty gas shortage, add dried longan meat porridge.
dizziness, hyperhidrosis, Riga barley porridge.
lungs and cough, Porridge Riga lily.
cool in summer and drugs, consumption of a variety mung bean porridge.
UFA and kidney, plus walnut porridge.
to lower blood pressure, porridge loading leaves.
Ziyin lungs good, porridge plus white fungus.
spring against meningitis, shepherd's purse good porridge.
spleen to aid digestion, porridge Tim Hawthorn.
dream more and forgetfulness, porridge Riga egg yolk.
diuretic treatment athlete's foot swelling, red bean porridge win supplements.
fluid and reducing fever and stomach, sugar cane porridge to fill the stomach.
colds and abdominal pain, ginger play do porridge.
ney Bugan and eyesight, wolfberry with porridge sweet.
efficacy of fruits and vegetables:
good lungs and phlegm pears, apples to stop diarrhea and nutritious. Effective weight loss of cucumber, kiwi fruit inhibit cancer.
blood to help face tomato, lotus root Chufan wonderful hangover. Orange good qi and phlegm, kidney warm leek knee waist. In addition to flatulence digestion
radish, celery can cure high blood pressure. Cabbage diuretic row toxins, cauliflower eat less cancer.
swelling diuretic melon, green beans detoxification high efficacy. Engage in casual blood stasis fungus cancer, kidney swelling yam consumption.
loose silt Results iodine kelp, mushrooms contain cancer cells. Pepper fend off the cold and dampness, onion spicy ginger for colds. Pig complement
milk fish, liver goat liver good eyesight. Yishenqiangxin waist eating walnuts, dates Jianshen Spleen eat.
bone soup
material:
fresh tibial, ginger, seven refer to the root peaches, tibial washed into the boiling water, boil for a short iron, and then wash away the blood.
ginger slices (three to five), seven means the peaches root clean, well tied with a clean string.
practice:
1. will be more than ready to put a pot with good material, add water (put some more water, plus enough time.)
2. set the fire, the fire boil, then turn slightly and simmer gently for about 2 hours, add a little salt, then braised for about 10 minutes off the fire can be.
bone health melon soup recipe
raw pork ribs soup: chop half a catty, melon 1 kg, salt, coriander.
system of law:
1, melon cut into inch pieces.
2, to the bloody hot ribs.
3, seven mature water boil the ribs, add melon and salt, until cooked, sprinkle with parsley.
Features: This soup tastes light, conducive to heat.
lotus root spare ribs soup
Material: pig ribs, lotus root of 500 grams of ginger a
seasonings: salt, rice wine, a small amount of
Method: 1, first with lotus root knife flat shot, let loose meat, lotus root, then cut hob, and then click salted, set aside;
2, the wash section of the ribs cut directly to the pot add cold water to boil, skim with a spoon Xuepao, Add the ginger one photographed, and then when you add lotus root stew boil until cooked.
3, according to their own tastes, adjustment to the salty, stew out of the lotus root soup, lotus root, sweet fragrance.
ribs bitter gourd soup
500 grams, 400 grams of pork ribs, scallion, ginger, Shaoxing wine, salt, MSG amount.
1, will be bitter to Guadi, to the flesh, cut into pieces; ribs washed and cut into small pieces.
2, pot, add some water, boil, add ribs cooked to Xuemo, remove and wash.
3, pot lit, into the ribs, water, with the fire boil, skim foam and put into spring onion, ginger, Shaoxing wine, low heat till the ribs Shulan, add cook bitter gourd about 10 minutes, add salt, MSG seasoning.
Microwave Method: Add pork, water, first 6 minutes of high fire, the soup boil, skim foam and put into scallion, ginger, Shaoxing wine, and then medium heat for 20 minutes to spare ribs cooked, put bitter after the first high heat 3 minutes, then medium heat 10 minutes.
Shulan and then into the ribs to be bitter, or melon easily scattered and fragmentary; with chicken powder instead of MSG, the taste better; This soup has a refreshing antipyretic effect in the microwave for easy and convenient, is the summer share.
taro pork ribs soup
Material: ribs, taro, ginger, spring onion, diced green onion, salt, MSG, cooking wine.
practice:
1. Taro, peeled and cut; ribs picked up into the boiling water burns.
2. Wu Wan pot into the water, before adding ribs, ginger, scallion boil and simmer over low heat about fifteen minutes, picked ginger, scallion not, then add taro and cook for about fifteen minutes, pour the next wine , salt, MSG seasoning, sprinkle with chopped green onion can be.
radish rib soup
material: a large white radish roots, small ribs
practice:
1, radish cross, each for about three centimeters thick, not too thin. Cut again, into the moon-shaped.
2, ribs fly water, that is placed in boiling water Cook for, and then rinse with cold water to remove the oil to the blood.
3, pot filled with water, the ribs in cold water pot, add ginger, star anise, onion, a little wine, cook for 20 minutes with a pressure cooker
4,20 points, into the pot, remove the froth, put radish.
5, then 20 minutes after the salt.
6, try the tasty Mody, well, on to the.
Note:
1, bao soup, pot of cold water are the basic materials is conducive to protein fully dissolved into the soup, and do not prematurely salt, the salt will also accelerate the coagulation of proteins, of soup the flavor.
2, put some vinegar, is conducive to calcium precipitation, preferably white vinegar will not damage the color of Tang.
raw seaweed soup ribs:
pork ribs 400 grams, 150 grams of seaweed, scallion, ginger, salt, rice wine, sesame oil and the right amount.
system of law:
1, after soaking the kelp, put Long Ti and steam for about half an hour, remove the water and then soaked for 4 hours, completely bubble, the wash water control, cut into squares; Wash pork ribs, cut with a knife along bones, chopped into about 4 cm in cross section, into the boiling pot to cook, remove and wash with warm water.
2, the net pot by adding 1,000 grams of water, into the ribs, scallion, ginger, rice wine, stir boiling, skim foam, and then opened fire with the fire stew about 20 minutes into the kelp block , and then stir boiling for 10 minutes, to pick ginger, spring onion, add salt seasoning, Drizzle sesame oil Serve.
Features: This soup Cornish rotten from bone, seaweed and slippery bad. The whole dish delicious, Tang Xian.
effect:
Therefore, together with seaweed stewed pork ribs can be systemic or limbs infested mainly to relieve pain in patients with localized pruritus.
ribs tomato soup
【Materials】 2 tomatoes, 600 grams of pork ribs, cabbage 1 / 4, coriander 2
】 【tomato sauce seasoning 4 tablespoons salt 1 teaspoon sauce 4 tbsp.
practice】 【
1, small ribs washed bloody boil for a short rinse to remove burns, and the other 10 cups water to boil, add ribs first boiled.
2, Wash cabbage, cut into small pieces, cook into the ribs, and finally cut into the tomato and tomato paste, salt to taste.
3, cook until slightly soft cooked rotten all the materials, add sauce thicken, when the soup is thick off Huosheng out, thrown into the coriander Serve.
ribs carrot soup
vitamin A than carrots, but also contain some sugar, protein and other nutrients, can promote the formation of hemoglobin, there was blood effect; ribs can be interest essence, strong bones. This Tangyou Run dry Yin, the raising of the effect of strong bones tendons.
ingredients: carrots, pork ribs 250 to 300 grams each, 2 slices ginger, cooking wine, salt, onion, monosodium glutamate the amount.
production: carrots, pork ribs washed, cut into pieces, add water amount. Will set the fire pot, stewing about 2 hours, the pan when transferred to wine, salt, ginger, green onions, cook for 20 minutes, add MSG Serve. Because people can add other favorite condiments such as vinegar can be added to make the soup more easily absorbed calcium.
features: pig Meat, carrots rotten, meat soup were very delicious taste buds.
rib soup carrot corn
[material:] carrots, corn, pig bones stick, salt, sesame oil, pepper
[system of law:]
1 , wash the pig bone rod knock off, carrots, potatoes washed, peeled, cut into pieces;
2, take the pressure cooker ignition, put the broth, stick bone boil, boil a few minutes into the carrots, potatoes, fire Kai Guo low heat;
3, the pan when the bones, carrots, potatoes leaching, salt, sesame oil, pepper Serve.
[Features:] gorgeous fragrance
Tieguanyin Chestnut rib soup
Main Material: Iron Goddess of Mercy 3 grams of tea a small row of 300 g
Ingredients: 120 g of fresh chestnut
Seasoning: 1 tsp salt
practices:
(1) Tie Guan Yin tea leaves in hot water 500 g filtered bubble tea after 1 minute, take tea aside.
(2) a small row of cut into small pieces (2 cm wide), after the wash with hot water boil for a short.
(3) put all materials into a round pot stew a half hours. Salt can be also on the table.
Participation Society for the corn soup
ribs Material: Codonopsis, Astragalus all 3 money, two of maize, small ribs catty
Seasoning: salt, 2 tsp
< br> approach:
① corn washed, chopped into small pieces, boiled pork ribs with hot water.
② all the materials and ingredients into the pot to the fire to boil, then simmer over low heat 40 minutes, clean wok before adding salt to taste
To not sleep, porridge Tim White Lotus.
backache kidney qi deficiency, put chestnut porridge.
guilty gas shortage, add dried longan meat porridge.
dizziness, hyperhidrosis, Riga barley porridge.
lungs and cough, Porridge Riga lily.
cool in summer and drugs, consumption of a variety mung bean porridge.
UFA and kidney, plus walnut porridge.
to lower blood pressure, porridge loading leaves.
Ziyin lungs good, porridge plus white fungus.
spring against meningitis, shepherd's purse good porridge.
spleen to aid digestion, porridge Tim Hawthorn.
dream more and forgetfulness, porridge Riga egg yolk.
diuretic treatment athlete's foot swelling, red bean porridge win supplements.
fluid and reducing fever and stomach, sugar cane porridge to fill the stomach.
colds and abdominal pain, ginger play do porridge.
ney Bugan and eyesight, wolfberry with porridge sweet.
efficacy of fruits and vegetables:
good lungs and phlegm pears, apples to stop diarrhea and nutritious. Effective weight loss of cucumber, kiwi fruit inhibit cancer.
blood to help face tomato, lotus root Chufan wonderful hangover. Orange good qi and phlegm, kidney warm leek knee waist. In addition to flatulence digestion
radish, celery can cure high blood pressure. Cabbage diuretic row toxins, cauliflower eat less cancer.
swelling diuretic melon, green beans detoxification high efficacy. Engage in casual blood stasis fungus cancer, kidney swelling yam consumption.
loose silt Results iodine kelp, mushrooms contain cancer cells. Pepper fend off the cold and dampness, onion spicy ginger for colds. Pig complement
milk fish, liver goat liver good eyesight. Yishenqiangxin waist eating walnuts, dates Jianshen Spleen eat.
bone soup
material:
fresh tibial, ginger, seven refer to the root peaches, tibial washed into the boiling water, boil for a short iron, and then wash away the blood.
ginger slices (three to five), seven means the peaches root clean, well tied with a clean string.
practice:
1. will be more than ready to put a pot with good material, add water (put some more water, plus enough time.)
2. set the fire, the fire boil, then turn slightly and simmer gently for about 2 hours, add a little salt, then braised for about 10 minutes off the fire can be.
bone health melon soup recipe
raw pork ribs soup: chop half a catty, melon 1 kg, salt, coriander.
system of law:
1, melon cut into inch pieces.
2, to the bloody hot ribs.
3, seven mature water boil the ribs, add melon and salt, until cooked, sprinkle with parsley.
Features: This soup tastes light, conducive to heat.
lotus root spare ribs soup
Material: pig ribs, lotus root of 500 grams of ginger a
seasonings: salt, rice wine, a small amount of
Method: 1, first with lotus root knife flat shot, let loose meat, lotus root, then cut hob, and then click salted, set aside;
2, the wash section of the ribs cut directly to the pot add cold water to boil, skim with a spoon Xuepao, Add the ginger one photographed, and then when you add lotus root stew boil until cooked.
3, according to their own tastes, adjustment to the salty, stew out of the lotus root soup, lotus root, sweet fragrance.
ribs bitter gourd soup
500 grams, 400 grams of pork ribs, scallion, ginger, Shaoxing wine, salt, MSG amount.
1, will be bitter to Guadi, to the flesh, cut into pieces; ribs washed and cut into small pieces.
2, pot, add some water, boil, add ribs cooked to Xuemo, remove and wash.
3, pot lit, into the ribs, water, with the fire boil, skim foam and put into spring onion, ginger, Shaoxing wine, low heat till the ribs Shulan, add cook bitter gourd about 10 minutes, add salt, MSG seasoning.
Microwave Method: Add pork, water, first 6 minutes of high fire, the soup boil, skim foam and put into scallion, ginger, Shaoxing wine, and then medium heat for 20 minutes to spare ribs cooked, put bitter after the first high heat 3 minutes, then medium heat 10 minutes.
Shulan and then into the ribs to be bitter, or melon easily scattered and fragmentary; with chicken powder instead of MSG, the taste better; This soup has a refreshing antipyretic effect in the microwave for easy and convenient, is the summer share.
taro pork ribs soup
Material: ribs, taro, ginger, spring onion, diced green onion, salt, MSG, cooking wine.
practice:
1. Taro, peeled and cut; ribs picked up into the boiling water burns.
2. Wu Wan pot into the water, before adding ribs, ginger, scallion boil and simmer over low heat about fifteen minutes, picked ginger, scallion not, then add taro and cook for about fifteen minutes, pour the next wine , salt, MSG seasoning, sprinkle with chopped green onion can be.
radish rib soup
material: a large white radish roots, small ribs
practice:
1, radish cross, each for about three centimeters thick, not too thin. Cut again, into the moon-shaped.
2, ribs fly water, that is placed in boiling water Cook for, and then rinse with cold water to remove the oil to the blood.
3, pot filled with water, the ribs in cold water pot, add ginger, star anise, onion, a little wine, cook for 20 minutes with a pressure cooker
4,20 points, into the pot, remove the froth, put radish.
5, then 20 minutes after the salt.
6, try the tasty Mody, well, on to the.
Note:
1, bao soup, pot of cold water are the basic materials is conducive to protein fully dissolved into the soup, and do not prematurely salt, the salt will also accelerate the coagulation of proteins, of soup the flavor.
2, put some vinegar, is conducive to calcium precipitation, preferably white vinegar will not damage the color of Tang.
raw seaweed soup ribs:
pork ribs 400 grams, 150 grams of seaweed, scallion, ginger, salt, rice wine, sesame oil and the right amount.
system of law:
1, after soaking the kelp, put Long Ti and steam for about half an hour, remove the water and then soaked for 4 hours, completely bubble, the wash water control, cut into squares; Wash pork ribs, cut with a knife along bones, chopped into about 4 cm in cross section, into the boiling pot to cook, remove and wash with warm water.
2, the net pot by adding 1,000 grams of water, into the ribs, scallion, ginger, rice wine, stir boiling, skim foam, and then opened fire with the fire stew about 20 minutes into the kelp block , and then stir boiling for 10 minutes, to pick ginger, spring onion, add salt seasoning, Drizzle sesame oil Serve.
Features: This soup Cornish rotten from bone, seaweed and slippery bad. The whole dish delicious, Tang Xian.
effect:
Therefore, together with seaweed stewed pork ribs can be systemic or limbs infested mainly to relieve pain in patients with localized pruritus.
ribs tomato soup
【Materials】 2 tomatoes, 600 grams of pork ribs, cabbage 1 / 4, coriander 2
】 【tomato sauce seasoning 4 tablespoons salt 1 teaspoon sauce 4 tbsp.
practice】 【
1, small ribs washed bloody boil for a short rinse to remove burns, and the other 10 cups water to boil, add ribs first boiled.
2, Wash cabbage, cut into small pieces, cook into the ribs, and finally cut into the tomato and tomato paste, salt to taste.
3, cook until slightly soft cooked rotten all the materials, add sauce thicken, when the soup is thick off Huosheng out, thrown into the coriander Serve.
ribs carrot soup
vitamin A than carrots, but also contain some sugar, protein and other nutrients, can promote the formation of hemoglobin, there was blood effect; ribs can be interest essence, strong bones. This Tangyou Run dry Yin, the raising of the effect of strong bones tendons.
ingredients: carrots, pork ribs 250 to 300 grams each, 2 slices ginger, cooking wine, salt, onion, monosodium glutamate the amount.
production: carrots, pork ribs washed, cut into pieces, add water amount. Will set the fire pot, stewing about 2 hours, the pan when transferred to wine, salt, ginger, green onions, cook for 20 minutes, add MSG Serve. Because people can add other favorite condiments such as vinegar can be added to make the soup more easily absorbed calcium.
features: pig Meat, carrots rotten, meat soup were very delicious taste buds.
rib soup carrot corn
[material:] carrots, corn, pig bones stick, salt, sesame oil, pepper
[system of law:]
1 , wash the pig bone rod knock off, carrots, potatoes washed, peeled, cut into pieces;
2, take the pressure cooker ignition, put the broth, stick bone boil, boil a few minutes into the carrots, potatoes, fire Kai Guo low heat;
3, the pan when the bones, carrots, potatoes leaching, salt, sesame oil, pepper Serve.
[Features:] gorgeous fragrance
Tieguanyin Chestnut rib soup
Main Material: Iron Goddess of Mercy 3 grams of tea a small row of 300 g
Ingredients: 120 g of fresh chestnut
Seasoning: 1 tsp salt
practices:
(1) Tie Guan Yin tea leaves in hot water 500 g filtered bubble tea after 1 minute, take tea aside.
(2) a small row of cut into small pieces (2 cm wide), after the wash with hot water boil for a short.
(3) put all materials into a round pot stew a half hours. Salt can be also on the table.
Participation Society for the corn soup
ribs Material: Codonopsis, Astragalus all 3 money, two of maize, small ribs catty
Seasoning: salt, 2 tsp
< br> approach:
① corn washed, chopped into small pieces, boiled pork ribs with hot water.
② all the materials and ingredients into the pot to the fire to boil, then simmer over low heat 40 minutes, clean wok before adding salt to taste
common office functions and tricks
Word trick:
one, enter the three , enter the three Enter the cell
= CHOOSE (WEEKDAY (I3, 2), Excel common functions Daquan
1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical logical
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7, 7,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &. com
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), , and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = DAY (
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).
to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array expressed as the front separated by an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).
reminded: The input is an array formula, you're finished, you need to by pressing The brace can not be directly input. 12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical TRUE
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, the C29 cell displays
remind: this article, similar to the the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.
remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet row or column number. 14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.
15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 characters.
reminded: This function name in English means
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find
reminded: Lookup_array can only be one column or row. 19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47
remind: the formula of the parameters, use the English state of the comma
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that
to remind: If the divisor parameter is zero, then the error value .
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical Otherwise, return a logical
using the format: OR (logical1, logical2, ...)< br> Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference form, and let the ref parameter to the absolute reference in the form (adding a mouse over the lower right corner of the cell, into thin cross-linear (usually called the complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)< br> Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.
to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to data rows or level area. 29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUMIF (C2: C63, .
to remind: If you modify the above formula: = SUMIF (C2: C63, Because it is text-based, needs to be placed under the English double quotes (
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68,
reminded: format_text parameters under the
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value see Table_array region must first column; If omitted Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (
one. Cell color effect
Select form, format - conditional formatting, conditions, select the
1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set the chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number, and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) <> 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0 < / p>
II. Color-filter
excel2007 can cell color, font color, or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name -> definitions, input a, input the following formula = get.cell (24, $ a1),
This method is available the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
==
1.Excel2003 no corresponding function, but can be called Get.Cell Excel4.0 a macro function, but the macro function can not be directly used directly in the Excel2003, the name must be defined to use
2. Get.Cell (Num, Cell) is the function of the format, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is to obtain the specified type of information that, out of 24 units is to make this function color information, taken out after a 1-56 number to represent color number
3. If you're out in B1 enter your name and fill out the definition, then the number is A1 B1 in the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, the color of the column by A sort of.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell
4 similar to the TYPE function
5
6 with reference to the text contents of the address reference to the address shown with reference to the formula
7 address format, text display text display
8 format
9 with reference to the address stored extra box on the left to return the style, the figures show
10 extra box store returns the right style, the figures show
11 store extra returns on the style side box, digital display
12 frame side return extra storage under the style, the figures show the internal pattern returned
13, figures show
14 If the cell is set to locked return True
15 is hidden if the formula returns True
16 returns the cell width
17 points as the unit returned to the cell height
18 words Type the name of
19 in points font size
20 return all or if the cell first character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 or if the cell of a character font of all the middle of a horizontal line returns True
24 returns the first character cell color number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56 < br> 57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name
one, enter the three , enter the three Enter the cell
= CHOOSE (WEEKDAY (I3, 2), Excel common functions Daquan
1, ABS function
function name: ABS
main functions: the absolute value of the corresponding figures obtained.
using the format: ABS (number)
Parameter Description: number to be requested on behalf of the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in both cell A2 enter a positive number (eg 100) or negative (eg -100), B2 in both show positive (eg 100).
to remind: If the number parameter is not numeric, but some characters (such as A, etc.), then the error value is returned B2
2, AND function
function name: AND
main functions: to return the logical value: if all parameters are the logical logical
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Example: enter the formula in cell C5: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 were greater than or equal to 60, if return FALSE, that the values in the A5 and B5 at least one of less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value
3, AVERAGE function
function name: AVERAGE
main functions: Find the arithmetic mean of all parameters.
using the format: AVERAGE (number1, number2, ... ...)
Parameter Description: number1, number2, ... ...: to request the reference value or the average cell (area), the parameter does not exceed 30.
Application examples: in B8 cells enter the formula: = AVERAGE (B7: D7, F7: H7, 7,8), is confirmed, you can find the area B7 to D7, F7 to H7 area values and average of 7,8.
to remind: If the reference area contains
4, COLUMN function
function name: COLUMN
main functions: display the column label reference value of the cell.
using the format: COLUMN (reference)
Parameter Description: reference to reference cell.
Application examples: In the cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (the B column).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; with the corresponding label value and a return line of the function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... the need to connect the characters of text or reference cell.
Application examples: In the cell C14 enter the formula: = CONCATENATE (A14 ,characters and. com connection as a whole, appears in cell C14.
to remind: If the argument is not a reference cell, and the text format, please give the English state parameters with double quotes, if you change the formula: = A14 &. com
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria the number of cells.
using the format: COUNTIF (Range, Criteria)
Parameter Description: Range on behalf of a range of cells to statistics; Criteria that specify the conditional expression.
Application examples: In the cell C17 enter the formula: = COUNTIF (B1: B13, the number of cells.
remind: to allow a range of cells referenced in the blank cells appear.
7, DATE function
function name: DATE
main functions: the values given in the specified date.
using the format: DATE (year, month, day)
Parameter Description: year value for the specified year (less than 9999); month for a specified number of months (can be greater than 12); day for a specified number of days .
Application examples: In the cell C20 enter the formula: = DATE (2003,13,35), confirmation, show 2004-2-4.
reminded: As the above formula, the month is 13, more than a month, postponed to January 2004; 35 days, compared with January 2004 the actual number of days the addition of 4 days, it is also extended to 2004 on February 4.
8, the function name: DATEDIF
main functions: calculate the difference between returns two date parameters.
using the format: = DATEDIF (date1, date2, a date, date2 on behalf of a date later; y (m, d) asked to return to the annual difference between the two dates (month, day) number.
Application examples: In the cell C23 enter the formula: = DATEDIF (A23, TODAY (), , and returns the number of years difference.
reminded: This is a hidden function in Excel, is found in the Function Wizard, you can use direct input for the calculation of age, length of service and so very effective.
9, DAY function
function name: DAY
main functions: Find the reference to a specified date or the date the cell number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = DAY (
to remind: If the given date, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns to meet the specified conditions and the number of cells that contain numbers.
using the format: DCOUNT (database, field, criteria)
Parameter Description: Database statistics said the need for a range of cells; Field said that the data used in the function list (must be marks on the first line item); Criteria include Conditions range of cells.
Application examples: Figure 1 shows, in cell F4, enter the formula: = DCOUNT (A1: D11, or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).
to remind: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can also achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array of data in an area frequency distribution.
using the format: FREQUENCY (data_array, bins_array)
Parameter Description: Data_array that used to calculate the frequency of a set of data or range of cells; Bins_array expressed as the front separated by an array of values.
Application examples: as shown in Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press key to confirm, you can find the B2 to the B31 area, according to D2 to D36 region separated values of the frequency of the number of segments (equivalent to the number of statistical segments of the score).
reminded: The input is an array formula, you're finished, you need to by pressing The brace can not be directly input. 12, IF function
function name: IF
main functions: According to the logic of the conditions specified in the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical representative of logic expressions; Value_if_true that determine the conditions when the logical TRUE
Application examples: In the cell C29 enter the formula: = IF (C26> = 18, the C29 cell displays
remind: this article, similar to the the corresponding cell, please refer to the specific instance of the file attached.
13, INDEX function
function name: INDEX
main functions: to return a list or array element value, this element by the row number and column number of the index values determined.
using the format: INDEX (array, row_num, column_num)
Parameter Description: Array on behalf of a range of cells or an array constant; Row_num that the specified line number (if omitted row_num, there must be column_num); Column_num that the specified column number (if omitted column_num, you must have row_num).
Application Example: Figure 3 shows, the F8 cell enter the formula: = INDEX (A1: D11, 4,3), confirmed the show range of cells A1 to D11, the first 4 rows and the intersection of three cells (ie, C4) in the content.
remind: line number argument here (row_num) and column number parameter (column_num) is relative to the terms of reference of the range of cells, not Excel worksheet row or column number. 14, INT function
function name: INT
main functions: the value rounded down to the nearest integer.
using the format: INT (number)
Parameter Description: number expressed the need for rounding numeric values or include a reference cell.
Example: enter the formula: = INT (18.89), confirmation shows 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), the result is returned to -19.
15, ISERROR function
function name: ISERROR
main functions: to test the functional return value for errors. If wrong, the function returns TRUE, otherwise returns FALSE.
using the format: ISERROR (value)
Parameter Description: Value that need to test the value or expression.
Example: enter the formula: = ISERROR (A35/B35), confirmation, if the B35 cell is empty or
reminded: This function is usually associated with supporting the use of IF functions, if you modify the formula: = IF (ISERROR (A35/B35 ),the cell appears empty, otherwise display A35/B35
results.
16, LEFT function
function name: LEFT
main functions: a text string from the first character, the interception of a specified number of characters.
using the format: LEFT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A38 characters.
reminded: This function name in English means
17, LEN function
function name: LEN
main functions: the number of characters in text string Statistics.
using the format: LEN (text)
Parameter Description: text, said text string to statistics.
Application example: assume that the cell holds the A41
reminded: LEN to statistics, whether in full-width characters, or half-width characters, each character are counted as
18, MATCH function
function name: MATCH
main functions: to return in the specified manner that matches the specified value of the corresponding elements in the array position.
using the format: MATCH (lookup_value, lookup_array, match_type)
Parameter Description: Lookup_value representatives need to look at the data sheet value;
Lookup_array that may contain the values you want to find a continuous range of cells;
Match_type find the way that the value of (-1,0 or 1).
match_type to -1 if, find the smallest greater than or equal to lookup_value value, Lookup_array must be in descending order;
If match_type to 1, less than or equal to lookup_value find the maximum value, Lookup_array must be sorted in ascending order ;
If match_type 0, find the first value is equal to lookup_value, Lookup_array can be arranged in any order; If omitted match_type, the default is 1.
Application examples: Figure 4 shows, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find
reminded: Lookup_array can only be one column or row. 19, MAX function
function name: MAX
main functions: Find the maximum value in a set of numbers.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the maximum value 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
20, MID function
function name: MID
main functions: a text string from the specified position, and the interception of a specified number of characters.
using the format: MID (text, start_num, num_chars)
Parameter Description: text represents a text string; start_num that specifies the starting position; num_chars that number to be intercepted.
Application example: assume that the cell holds the A47
remind: the formula of the parameters, use the English state of the comma
21, MIN function
function name: MIN
main functions: Find the minimum value in a set of numbers.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum value or a reference cell (area), the parameter does not exceed 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to the J44 cells and in the region and the minimum values 7,8,9,10 .
to remind: If the parameters are text or logical values, is ignored.
22, MOD function
function name: MOD
main functions: Find the remainder of dividing two numbers.
using the format: MOD (number, divisor)
Parameter Description: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show that
to remind: If the divisor parameter is zero, then the error value .
23, MONTH function
function name: MONTH
main functions: Find the reference to a specified date or the date cell of the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number on behalf of the specified date, or reference cell.
Example: enter the formula: = MONTH (
to remind: If the given date, include double quotation marks in English; if you modify the formula: = YEAR (
24, NOW function
function name: NOW
main functions: given the current system date and time.
using the format: NOW ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = NOW (), immediately after confirmation showing the current system date and time. If the system date and time changed, just click the F9 function key, you can let it change.
reminded: display the date and time format, you can re-set the cell formatting.
25, OR function
function name: OR
main functions: to return a logical value, only if all parameter values are logical Otherwise, return a logical
using the format: OR (logical1, logical2, ...)< br> Parameter Description: Logical1, Logical2, Logical3 ... ...: the conditions to be tested, said the value or expression, up to the 30.
Application examples: In the cell C62 enter the formula: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, A62 and B62 in that at least one value greater than or equal to 60, if the return FALSE, that the values in A62 and B62 are less than 60.
to remind: If you specify a logical condition parameter contains non-logical values, then the function returns the error value
26, RANK function
function name: RANK
main functions: to return a numeric value in a column in the ranking relative to other values.
using the format: RANK (Number, ref, order)
Parameter Description: Number values to sort the representative; ref numerical order in which the representatives of a range of cells; order on behalf of sort parameters (if it is ignored, according ranked in descending order, the larger the number, the smaller the value of ranking results; if non-
Example: If cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), D 1 can be derived after confirmation of language students in his class ranking in the results results.
remind: In the above formula, we let the Number parameter to a relative reference form, and let the ref parameter to the absolute reference in the form (adding a mouse over the lower right corner of the cell, into thin cross-linear (usually called the complete ranking scores of other students language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character in the beginning, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text representative of the character string to be cut; num_chars interception of a given number of representatives.
Application example: assume that the cell holds the A65 characters.
reminded: Num_chars parameter must be greater than or equal to 0, if omitted, the default it is 1; num_chars parameter is greater than if the length of the text, the function returns the entire text.
28, SUBTOTAL function
function name: SUBTOTAL
main functions: to return a list or database subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...)< br> Parameter Description: Function_num 1 to 11 (includes hidden values) or 101-111 (ignores hidden values) between the figures for What is the function specified in the list with subtotals calculated (Figure 6); ref1, ref2, ... ... on behalf of regional or subtotals to be a reference to not more than 29.
Application examples: as shown in Figure 7, the cells in the B64 and C64, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former appear as 62 (including the hidden rows), which appears as 61, not including the hidden rows.
to remind: If you take automated screening, no matter what type function_num parameters are chosen, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function is applied to the data columns or vertical area, does not apply to data rows or level area. 29, the function name: SUM
main functions: the calculation of all parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... need to calculate the representative value may be a specific value, a reference cell (area), logical values and so on.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUM (D2: D63), confirmed the language of the score can be calculated.
to remind: If the argument is an array or reference, only one of the numbers will be calculated. Blank the array or reference cells, logical values, text or error values are ignored; if you modify the formula: = SUM (LARGE (D2: D63, {1,2,3,4,5})), you can find the top 5 results and.
30, SUMIF function
function name: SUMIF
main functions: to meet specified conditions for calculating the value and the range of cells.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range to determine the range of cells representative of conditions; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application examples: as shown in Figure 7, in the cell D64 enter the formula: = SUMIF (C2: C63, .
to remind: If you modify the above formula: = SUMIF (C2: C63, Because it is text-based, needs to be placed under the English double quotes (
31, TEXT function
function name: TEXT
main functions: the value specified format according to the corresponding number into text form.
using the format: TEXT (value, format_text)
Parameter Description: value to convert the value on behalf of or reference to the cell; format_text for the specified text in the form of digital format.
Example: If the B68 cell preservation values 1280.45, we enter the formula in cells C68: = TEXT (B68,
reminded: format_text parameters under the
32, TODAY function
function name: TODAY
main functions: given the system date.
using the format: TODAY ()
Parameter Description: This function takes no arguments.
Example: enter the formula: = TODAY (), confirm that immediately after the system date and time display. If the system date and time changed, just click the F9 function key, you can let it change.
remind: the date format displayed, you can re-set the cell format (see annex).
33, VALUE function
function name: VALUE
main functions: the value of a text on behalf of the string is converted to numeric type.
using the format: VALUE (text)
Parameter Description: text-based representatives need to convert the text string value.
Example: If the B74 cell function is the interception by LEFT and other text-based strings, we enter the formula in cells C74: = VALUE (B74), confirmed, can be converted to numeric.
to remind: If the text type value is not a result of these conversions, the use of the function to deal with these values, often returns error.
34, VLOOKUP function
function name: VLOOKUP
main functions: the first column in the data table to find the specified value, and thus returns the current row in the table at the specified column value.
using the format: VLOOKUP (lookup_value, table_array, col_index_num, range_lookup)
Parameter Description: Lookup_value representatives need to find value; Table_array representatives need to find data in which the range of cells; Col_index_num in the region to be returned table_array match the value of the column number (when Col_index_num is 2, the return table_array values in column 2, 3, the return value of column 3 ... ...); Range_lookup is a logical value, if it is TRUE or omitted, the return approximate match, that is, if can not find an exact match, it returns the maximum value of less than lookup_value; If FALSE, it returns an exact match, if not, it returns the error value # N / A.
Application example: see Figure 7, we enter the formula in cell D65: = VLOOKUP (B65, B2: D63, 3, FALSE), confirmed, as long as the cell B65, enter a student's name (such as D 48), D65 cells showed immediate results of the student's language.
reminded: Lookup_value see Table_array region must first column; If omitted Range_lookup parameters, Table_array the first column must be sorted; the Wizard in this function, the Range_lookup parameter usage is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the date given corresponds to the specified number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number on behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of weeks [when the Sunday (Sunday) to 1, Saturday (Saturday ) is 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese habit of); when Monday (Monday) to 0 , Sunday (Sunday) to 6, this parameter is 3].
Example: enter the formula: = WEEKDAY (TODAY (), 2), confirm the system date is given after the number of weeks.
to remind: If the specified date, please put the English under the double quotes, such as = WEEKDAY (
one. Cell color effect
Select form, format - conditional formatting, conditions, select the
1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlaced color effect (even row colors):
= MOD (ROW (), 2) = 0
3. If you want to set the format for each application of a shading line 3, you can use the formula:
= MOD (ROW (), 3) = 1
4. If you want to set different odd and even column shading, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set the chess checkerboard shading (white + custom color):
= MOD (ROW () + COLUMN (), 2)
Description: The conditional formatting formula used to determine the line number and column number, and the remainder is divided by 2 to 0. If 0, indicating the number of rows and columns of the same parity, then fill the cell to the specified color, or not filled. In the conditional formatting, the formula results to return a number, non-0 numbers is the TRUE, 0, and the error value is FALSE. Therefore, the above formula can be written as:
= MOD (ROW () + COLUMN (), 2) <> 0
6. If you want to set the chess checkerboard shading (custom colors + custom color):
add style 2:
= MOD (ROW () + COLUMN (), 2) = 0 < / p>
II. Color-filter
excel2007 can cell color, font color, or icon to be sorted.
If excel2003, need to add auxiliary column, the name of the method defined by the color of the corresponding number, then the secondary sort column:
color cell in column A, select B1, Insert -> Name -> definitions, input a, input the following formula = get.cell (24, $ a1),
This method is available the serial number of the font color. B1 enter = a copy the formula down to the appropriate line.
the full table can be sorted by column B. If want to get the background color of the serial number will be changed to 63 to 24.
==
1.Excel2003 no corresponding function, but can be called Get.Cell Excel4.0 a macro function, but the macro function can not be directly used directly in the Excel2003, the name must be defined to use
2. Get.Cell (Num, Cell) is the function of the format, Get.Cell can get a cell in a variety of information, such as frame format, etc., Num is to obtain the specified type of information that, out of 24 units is to make this function color information, taken out after a 1-56 number to represent color number
3. If you're out in B1 enter your name and fill out the definition, then the number is A1 B1 in the color code, B2 is A2 in the figure will be the color code, and so
4. Now you press the B column sort, in fact, the color of the column by A sort of.
attached Get.Cell the meaning of each parameter:
1 refer to the absolute address cell reference cells
2 No.
3 column reference column number cell
4 similar to the TYPE function
5
6 with reference to the text contents of the address reference to the address shown with reference to the formula
7 address format, text display text display
8 format
9 with reference to the address stored extra box on the left to return the style, the figures show
10 extra box store returns the right style, the figures show
11 store extra returns on the style side box, digital display
12 frame side return extra storage under the style, the figures show the internal pattern returned
13, figures show
14 If the cell is set to locked return True
15 is hidden if the formula returns True
16 returns the cell width
17 points as the unit returned to the cell height
18 words Type the name of
19 in points font size
20 return all or if the cell first character is bold return True
21 If all or a cell in italics the first character returns True
22 If all or a cell first character is a single bottom line returns True
23 or if the cell of a character font of all the middle of a horizontal line returns True
24 returns the first character cell color number, 1 to 56. If set to automatic, returns 0
25 MS Excel does not support the outline format
26 MS Excel format does not support the shadow figures
27 insert page breaks manually set the outline of the column
28 Outline of the field-level
29
30 if the level of the outline summary of the range compared to True
31 if the range is the outline of the summary column was True
32 shows the workbook and worksheet name of the
33 If the cell formatting for multiple lines of text compared to True
34 extra storage box on the left to return the color, figures show. If set to automatic, returns 0
35 extra storage box on the right to return the color, figures show. If set to automatic, returns 0
36 extra storage box at the top to return color, figures show. If set to automatic, returns 0
37 return save extra box below the color, figures show. If set to automatic, returns 0
38 cells future returns shadow colors, figures show. If set to automatic, returns 0
39 returns the cell back shadow color, figures show. If set to automatic, returns 0
40 text display cell style
41 returns the address of the original equation reference
42 points as the unit returned to the use of the left window on the left to the level of cell Distance
43 in points in the top of the window to return to using the cell above the vertical distance
44 in points in the window on the left to return to the use of a cell to the right of the horizontal distance
45 points unit returns to the top of the window used in the cell below the vertical distance
46 are inserted comments if the cell returns True
47 if the cell has to insert a sound prompt return True
48 are inserted into the formula if cell Returns True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, the figures show
51 perpendicular to the direction of the cell returned, figures show
52 pass back to the cell prefix character
53 text display shows the contents of the cell returned
54 returns the name of the PivotTable cell
55 returns the cell in the PivotTable pivot position
56 < br> 57 If all or a cell first character is superscript text return True
58 shows return of all or a cell font style
59 characters return the cell bottom line style, the figures show
60 If all or a cell for the first character subscript returns True
61 pivot
62 shows the workbook and worksheet name
63 returns the fill color of a cell mass
64 Back to the drawing foreground color
65 pivot
66 shows the workbook name
Monday, April 11, 2011
Do not go to bed classic and young women
Do not go to bed
a man and young women go to the market sale of pigs, dark and the rain, twenty pigs are not sold as, to a farmhouse for shelter.
young woman said: only one person at home inconvenience.
M: Please, big sister, to a pig.
Woman: Well, but the house was only one bed.
M: I went to bed to sleep, give a pig.
Female: Yes.
middle of the night men and women to discuss, I went to sleep on top of you, women would not.
M: two pigs.
women allowed to require up unable to move.
awhile, men can not help, begged moving about, women would not.
M: moving about two pigs. Women agreed.
eight men moved to stop, women asked why not move?
man said not a pig.
woman whispered to me: 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-to guide, develop user requirements, 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 sale of pigs, dark and the rain, twenty pigs are not selling into, the young woman to a farmhouse for shelter
said: home, only one inconvenience.
M: Please, big sister, to a pig
Woman: Well, but the house was only one bed.
M: I went to bed to sleep, give a pig.
Female: Yes.
middle of the night men business woman, I went to sleep on top of you, women would not.
M: two pigs.
women allowed to require up unable to move.
awhile, men can not help, begged moving about, women would not.
M: moving about two pigs. Women agreed.
seven men stopped moving, women asked why not move?
, said: get away ~ ~ ~ Female: ... ...
dawn, the male head down to catch two pigs to Market to the ... ...
Harvard Instructor Comments: To be careful with the size of their own investment funds strand breaks to guard against the problem
※ ※ ※ ※ ※ ※ ※ ※
another man about the incident, determined to do the same and learn, then Viagra store with a pig go to enchant a Viagra, and then proceed with 19 pigs, everything has to be, morning, the male whistling drive 37 (including the young woman home 18) Pigs to Market to the ... ...
Harvard Instructor comments: If companies get the help of financial capital, its operational capacity will be doubled.
※ ※ ※ ※ ※ ※ ※ ※
know this method more than men, Viagra in short supply, and gradually to 2 pigs for a Viagra, then the 3 pigs for a Viagra, Viagra Viagra, announced the limited supply store , always hedge against inflation.
Harvard Instructor Comments: This is inflation, but despite the purchase of Viagra, Viagra is always hedging products, from a pig to the N pigs for a Viagra, when you devaluation seen the Viagra?
※ ※ ※ ※ ※ ※ ※ ※
more and more people heard about the comments instructors at Harvard, began to hoard Viagra and Viagra in the secondary trading market to make money. Harvard mentors
comment: prosperous secondary trading market is the primary market to ensure continued prosperity.
※ ※ ※ ※ ※ ※ ※ ※
more and more people want to fry Viagra Viagra prices quickly rose to 16 for a pig.
Harvard mentors Comments: The man has entered the marginal cost, in addition to have confidence in their own ability and future good intentions, actual current swine have been zero.
※ ※ ※ ※ ※ ※ ※ ※
some male only an early switch to Viagra, a pig, so he was told that you can use your Viagra is now running a pig for this mortgage, you had a pig buy Viagra now the value of 16 pigs, you can do a loan of at least 8 pigs, and then you can buy cars and so the pigs a good thing, which can be part of your value to the consumption of Viagra.
Harvard Instructor Comments: Good financial management can enable individuals to achieve financial freedom.
※ ※ ※ ※ ※ ※ ※ ※
for male pigs are more and more stores decided to Viagra, Viagra sales model to launch a loan, even if you do not have sufficient cash pigs, as long as you dare to promise to the girl room in the night, with 16 pigs back, I can put Viagra to sell you. For example, if you lack a pig, can be due to one, things are after the money pay pig, this method greatly facilitated Viagra sales.
Harvard Instructor Comments: This is the loan, so that enterprises can borrow based on future revenue options liquidity. Expansion of production capacity, which is credit economy and credit economy is built on good faith and on the basis of sustained economic growth, as long as we are disloyal, Viagra can be continuously available to everyone to use.
※ ※ ※ ※ ※ ※ ※ ※
Viagra tasted the sweetness of store, borrowing more and more daring, and later in a pig even if you have not, as long as you promised to the woman one night room, can be by, things are after the money pay pig.
Harvard Instructor Comments: This is financial innovation, so that people now 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, this project great, 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 divided into three categories for men and pigs, one pig for now is holding, and one is part of the loans are pigs , and one is not present by pigs, the issuance of three bonds. A lively and on. Stores have to buy the bonds Viagra, Viagra store business is very good, put the bond sales operations outsourced to another company, the company also be great fortunes, the company grew and grew, and even unrealistic Viagra sales case to issue, to the stores themselves and Viagra huge cash income.
Harvard Instructor Comments: This is the professional people to do the professional thing, operating to the capital from the physical operation of the economy into a higher level.
※ ※ ※ ※ ※ ※ ※ ※
their bonds in order to prevent future losses, the company decided to give it to buy the insurance, bond sales so much easier, because once the bonds have problems, you can also get insurance companies, the insurance company, one calculation, so far about the low rate of Viagra sales Wei, after all, sex is a rigid demand, must be met, as long as the commitment to accept the premium, you can get a great income, and low default risk . Wow, all the bonds if the insurance company claims there is a problem, the bond sales which erupted in great company, the insurance company was also a great income insurance for nothing.
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 men and too many pigs, 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, belonging to normal market fluctuations will not affect the entire economy.
※ ※ ※ ※ ※ ※ ※ ※
result has been reluctant to move back to the woman. Part of the male pigs due to no income, had announced its willingness to exchange cheap Viagra, Viagra, a sudden drop from 16 to 8 pigs can not sell a pig, Viagra market panic could plunge the original Viagra, some with Viagra bilk people, the result is a large number of loan maturity can not return to pigs, Viagra store dizzy, have announced that a large number of borrowers who did not return due to pigs, are credit default.
Harvard Instructor Comments: This is a personal act, most of the loans are high-quality crowd.
※ ※ ※ ※ ※ ※ ※ ※
defaults on subprime loans pigs, then will correspond to their worthless bonds, corporate bonds sold bear a look at 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,
※ ※ ※ ※ ※ ※ ※ ※
instructor at Harvard where the company also knew the bond on the bond insurance, insurance company to look, where it can afford to lose, so also announced it would close down.
Harvard Instructor Comments: This is the financial crisis will not affect the real economy.
※ ※ ※ ※ ※ ※ ※ ※
large numbers of people bankrupt, not consumer, after the economic downturn, the pigs did not dare to lend, for fear never to return, the market getting cold!
Harvard Instructor comments: the National People have the time to bleeding, while those who sell Viagra, selling bonds, and selling insurance at the time made a fortune making money, and now come up with funnel, if we do not help them pay for , or we will suffer most.
※ ※ ※ ※ ※ ※ ※ ※
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, pig, and very angry, who took us pig?
Harvard Instructor Comments: already told you, why do not control? The only way now is to find a few foreign pig farmers to the image of a responsible big country to note pig pig, otherwise we all have to finished!
※ ※ ※ ※ ※ ※ ※ ※
later: It is said that the woman had moved to settle in China, in addition to several graduate with a Harvard professor is also gold in China.
Reading Tip: Pig in cash, Viagra is the house.
a man and young women go to the market sale of pigs, dark and the rain, twenty pigs are not sold as, to a farmhouse for shelter.
young woman said: only one person at home inconvenience.
M: Please, big sister, to a pig.
Woman: Well, but the house was only one bed.
M: I went to bed to sleep, give a pig.
Female: Yes.
middle of the night men and women to discuss, I went to sleep on top of you, women would not.
M: two pigs.
women allowed to require up unable to move.
awhile, men can not help, begged moving about, women would not.
M: moving about two pigs. Women agreed.
eight men moved to stop, women asked why not move?
man said not a pig.
woman whispered to me: 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-to guide, develop user requirements, 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 sale of pigs, dark and the rain, twenty pigs are not selling into, the young woman to a farmhouse for shelter
said: home, only one inconvenience.
M: Please, big sister, to a pig
Woman: Well, but the house was only one bed.
M: I went to bed to sleep, give a pig.
Female: Yes.
middle of the night men business woman, I went to sleep on top of you, women would not.
M: two pigs.
women allowed to require up unable to move.
awhile, men can not help, begged moving about, women would not.
M: moving about two pigs. Women agreed.
seven men stopped moving, women asked why not move?
, said: get away ~ ~ ~ Female: ... ...
dawn, the male head down to catch two pigs to Market to the ... ...
Harvard Instructor Comments: To be careful with the size of their own investment funds strand breaks to guard against the problem
※ ※ ※ ※ ※ ※ ※ ※
another man about the incident, determined to do the same and learn, then Viagra store with a pig go to enchant a Viagra, and then proceed with 19 pigs, everything has to be, morning, the male whistling drive 37 (including the young woman home 18) Pigs to Market to the ... ...
Harvard Instructor comments: If companies get the help of financial capital, its operational capacity will be doubled.
※ ※ ※ ※ ※ ※ ※ ※
know this method more than men, Viagra in short supply, and gradually to 2 pigs for a Viagra, then the 3 pigs for a Viagra, Viagra Viagra, announced the limited supply store , always hedge against inflation.
Harvard Instructor Comments: This is inflation, but despite the purchase of Viagra, Viagra is always hedging products, from a pig to the N pigs for a Viagra, when you devaluation seen the Viagra?
※ ※ ※ ※ ※ ※ ※ ※
more and more people heard about the comments instructors at Harvard, began to hoard Viagra and Viagra in the secondary trading market to make money. Harvard mentors
comment: prosperous secondary trading market is the primary market to ensure continued prosperity.
※ ※ ※ ※ ※ ※ ※ ※
more and more people want to fry Viagra Viagra prices quickly rose to 16 for a pig.
Harvard mentors Comments: The man has entered the marginal cost, in addition to have confidence in their own ability and future good intentions, actual current swine have been zero.
※ ※ ※ ※ ※ ※ ※ ※
some male only an early switch to Viagra, a pig, so he was told that you can use your Viagra is now running a pig for this mortgage, you had a pig buy Viagra now the value of 16 pigs, you can do a loan of at least 8 pigs, and then you can buy cars and so the pigs a good thing, which can be part of your value to the consumption of Viagra.
Harvard Instructor Comments: Good financial management can enable individuals to achieve financial freedom.
※ ※ ※ ※ ※ ※ ※ ※
for male pigs are more and more stores decided to Viagra, Viagra sales model to launch a loan, even if you do not have sufficient cash pigs, as long as you dare to promise to the girl room in the night, with 16 pigs back, I can put Viagra to sell you. For example, if you lack a pig, can be due to one, things are after the money pay pig, this method greatly facilitated Viagra sales.
Harvard Instructor Comments: This is the loan, so that enterprises can borrow based on future revenue options liquidity. Expansion of production capacity, which is credit economy and credit economy is built on good faith and on the basis of sustained economic growth, as long as we are disloyal, Viagra can be continuously available to everyone to use.
※ ※ ※ ※ ※ ※ ※ ※
Viagra tasted the sweetness of store, borrowing more and more daring, and later in a pig even if you have not, as long as you promised to the woman one night room, can be by, things are after the money pay pig.
Harvard Instructor Comments: This is financial innovation, so that people now 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, this project great, 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 divided into three categories for men and pigs, one pig for now is holding, and one is part of the loans are pigs , and one is not present by pigs, the issuance of three bonds. A lively and on. Stores have to buy the bonds Viagra, Viagra store business is very good, put the bond sales operations outsourced to another company, the company also be great fortunes, the company grew and grew, and even unrealistic Viagra sales case to issue, to the stores themselves and Viagra huge cash income.
Harvard Instructor Comments: This is the professional people to do the professional thing, operating to the capital from the physical operation of the economy into a higher level.
※ ※ ※ ※ ※ ※ ※ ※
their bonds in order to prevent future losses, the company decided to give it to buy the insurance, bond sales so much easier, because once the bonds have problems, you can also get insurance companies, the insurance company, one calculation, so far about the low rate of Viagra sales Wei, after all, sex is a rigid demand, must be met, as long as the commitment to accept the premium, you can get a great income, and low default risk . Wow, all the bonds if the insurance company claims there is a problem, the bond sales which erupted in great company, the insurance company was also a great income insurance for nothing.
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 men and too many pigs, 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, belonging to normal market fluctuations will not affect the entire economy.
※ ※ ※ ※ ※ ※ ※ ※
result has been reluctant to move back to the woman. Part of the male pigs due to no income, had announced its willingness to exchange cheap Viagra, Viagra, a sudden drop from 16 to 8 pigs can not sell a pig, Viagra market panic could plunge the original Viagra, some with Viagra bilk people, the result is a large number of loan maturity can not return to pigs, Viagra store dizzy, have announced that a large number of borrowers who did not return due to pigs, are credit default.
Harvard Instructor Comments: This is a personal act, most of the loans are high-quality crowd.
※ ※ ※ ※ ※ ※ ※ ※
defaults on subprime loans pigs, then will correspond to their worthless bonds, corporate bonds sold bear a look at 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,
※ ※ ※ ※ ※ ※ ※ ※
instructor at Harvard where the company also knew the bond on the bond insurance, insurance company to look, where it can afford to lose, so also announced it would close down.
Harvard Instructor Comments: This is the financial crisis will not affect the real economy.
※ ※ ※ ※ ※ ※ ※ ※
large numbers of people bankrupt, not consumer, after the economic downturn, the pigs did not dare to lend, for fear never to return, the market getting cold!
Harvard Instructor comments: the National People have the time to bleeding, while those who sell Viagra, selling bonds, and selling insurance at the time made a fortune making money, and now come up with funnel, if we do not help them pay for , or we will suffer most.
※ ※ ※ ※ ※ ※ ※ ※
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, pig, and very angry, who took us pig?
Harvard Instructor Comments: already told you, why do not control? The only way now is to find a few foreign pig farmers to the image of a responsible big country to note pig pig, otherwise we all have to finished!
※ ※ ※ ※ ※ ※ ※ ※
later: It is said that the woman had moved to settle in China, in addition to several graduate with a Harvard professor is also gold in China.
Reading Tip: Pig in cash, Viagra is the house.
Thursday, April 7, 2011
Delicious!
Two kinds of pickled cucumbers recipes , most people do not tell him we
cucumber: 5 pounds of ginger: 2 halves of garlic: 2 halves
sauce: 2 half kilogram of salt: catty ; sugar: 3 half
two spirits: 3 in two Capsicum: 1 kg ; MSG: 1 two
* Peanut oil: 2 two
Note: One of peanut oil to be boiling, let cool to use!
preserved can be consumed the next day! (You can also add some garlic, good taste)
detached system pickle sauce
1. cucumber pounds, cut into below look like.
2. Cut pound after a good sprinkling of salt (less if you do, according to the percentage decline on the line, do not worry about salt, the salt is to blaze inside of cucumber water, salt would be mostly with the current go.)
3. the mix of cucumber sprinkled with salt, put cucumber in the water squeezed out as much as possible.
4. according to their own tastes, prepared ginger, garlic, and I like spicy food, but also for the spicy. set aside the morning, set aside.
5. three bags of soy sauce, sugar, half a catty into the pot, boil until the soy sauce, sugar, melted off the fire, find a container into the cool.
6. The next day, seven in the morning, killed the cucumber water. Then put the sauce in the soup, then added: cucumber, ginger, garlic, pepper, mix well.
7. Add white wine (be sure to put the taste very good), MSG (do not like to hold) a little.
8. the fire to do the pot, put oil, oil heat, add a little pepper, until the oil temperature close to room temperature, poured into just soaked cucumber and put it into glass jars; can try releasing pepper taste good
it! three days after the food tastes the best.
top-secret recipe cucumber sauce (do not tell anyone 吆)
1. Cucumber 10 pounds
2.
both small pepper 0.5 kg with a pound of salt water flooding will be squeezed out through
3. garlic 7, sliced
4. Ginger (preferably ginger) peeled and sliced 0.5 pounds
5. sugar 1 kg
6. liquor 0.4-0.5 kg
7. soy sauce 3 pounds
8. salad oil, 0.3 kg
9 . MSG 0.4 kg
sealed ingredients into the pot, a few days you can eat.
cucumber: 5 pounds of ginger: 2 halves of garlic: 2 halves
sauce: 2 half kilogram of salt: catty ; sugar: 3 half
two spirits: 3 in two Capsicum: 1 kg ; MSG: 1 two
* Peanut oil: 2 two
Note: One of peanut oil to be boiling, let cool to use!
preserved can be consumed the next day! (You can also add some garlic, good taste)
detached system pickle sauce
1. cucumber pounds, cut into below look like.
2. Cut pound after a good sprinkling of salt (less if you do, according to the percentage decline on the line, do not worry about salt, the salt is to blaze inside of cucumber water, salt would be mostly with the current go.)
3. the mix of cucumber sprinkled with salt, put cucumber in the water squeezed out as much as possible.
4. according to their own tastes, prepared ginger, garlic, and I like spicy food, but also for the spicy. set aside the morning, set aside.
5. three bags of soy sauce, sugar, half a catty into the pot, boil until the soy sauce, sugar, melted off the fire, find a container into the cool.
6. The next day, seven in the morning, killed the cucumber water. Then put the sauce in the soup, then added: cucumber, ginger, garlic, pepper, mix well.
7. Add white wine (be sure to put the taste very good), MSG (do not like to hold) a little.
8. the fire to do the pot, put oil, oil heat, add a little pepper, until the oil temperature close to room temperature, poured into just soaked cucumber and put it into glass jars; can try releasing pepper taste good
it! three days after the food tastes the best.
top-secret recipe cucumber sauce (do not tell anyone 吆)
1. Cucumber 10 pounds
2.
both small pepper 0.5 kg with a pound of salt water flooding will be squeezed out through
3. garlic 7, sliced
4. Ginger (preferably ginger) peeled and sliced 0.5 pounds
5. sugar 1 kg
6. liquor 0.4-0.5 kg
7. soy sauce 3 pounds
8. salad oil, 0.3 kg
9 . MSG 0.4 kg
sealed ingredients into the pot, a few days you can eat.
Wednesday, April 6, 2011
Seven fresh steamed fish recipe (to )
All the methods Zhu Yu, steamed fish can be said to be the most popular. After the fish steamed fresh, delicious, mainly preserved fish nutrition. Although fish is a simple steamed vegetables, sat up, but there are a lot of tips.
Let's take a look , steamed fish, the production process should pay attention to details.
cooking method for all the fish, steamed fish, nutrients are the best method of preservation, recommended!
Tip one: fish weight control at 600 grams, the volume of this size, placed in the fish dish, looks beautiful, but also raw and cooked a good grasp of the furnace;
Tip two: clean up the fish, the fish spine can be cut off from the abdominal (tail amputated with a knife), to prevent the fish, steamed fish, the fish bone shrinkage leaving the overall deformation, but if you Comparison of strange craft, do not cut the line too, so have not started steaming, put the fish spoil deformation.
clean up the fish after the fish on both sides spread your lard (edible vegetable oil also improvise is), then stained with a little white wine (you can also try to stick some wine, and perhaps also created a new flavor);
Tip three: to about 50 grams of meat mix a little soy sauce, sesame oil, salt, ginger, shiitake mushrooms into the belly of the fish after the end, it can enable more fresh fish, but also prop up the belly of the fish taste so steamed fish body full;
Tip four: take large ginger, cut into uniform to take the longest section of the thin filament beautiful, take the middle of the green onions (Buqingbubai Department, and ginger so long) strips, (for aesthetic to induce loss of appetite) shop in the fish plate, fish the fish into the dish and then sprinkle some onion ginger silk;
Tip Five: Be sure to open water after the steamer, and then the fish wok (do not fish on a steaming pot of cold water, then fall through the. a lot of steamed vegetables are the secret to open, the food went in the water steam);
Tip six: 6-7 minutes to steam off the heat (the furnace is top secret);
Tip seven: off after the fire, do not open the lid, the fish did not pan out, the use of pot Yu Wen vinegar, edible vegetable oil, little salt or no salt) poured over the fish (can not put MSG in order to light, fresh), and then put on a few scattered at random and began to eat parsley before serving.
Features: This tender such as fish, tofu, incense, such as crab meat, light and refreshing. If you eat when there are others here, you want to quietly aligned belly of the fish chopsticks as soon as possible (the most fragrant essence of the most tender place), pre-emptive!
points to add:
1, if it is steamed lotus grass carp and other larger fish or fish (weight should be controlled at 1000 grams), steaming time can be extended by 2-3 minutes, but not too long. Do not forget the
2, can also be a good tune, ready to finally pour in the fish body (soy sauce, vinegar, oil) juice in a small bowl, and steam the fish with the pot, until the fish pan, it will Remove the sauce from the pot, pour in the fish, this sauce compared to the previous raw juice, a little something jerky, fish taste better warm fragrant and soft, suitable for the elderly and those who like the light taste.
3, steaming slightly larger fish, the fish from shelves in the two chopsticks to make a fish out of the chassis overhead, fully exposed to heat the instant the fish, after the pan in the kitchen, quietly withdraw the chopsticks out, do not let Chike find your tips.
4, steaming slightly larger fish, the fish can also be set up (like a fish swimming in the water the way) steam. At this time, can be a saving of 5 cm-long green onions softened belly of the fish, stable and unchanging, so that the fish, put the fish on both sides buckle fixed two small ceramic fish bowl (hold the meat inside the belly of the fish.)
At this point, you can also fish on both sides of each side of the plane in Mito, tool joints in each folder into a ginger. Steamed fish, it will withdraw another small bowl and serve.
Let's take a look , steamed fish, the production process should pay attention to details.
cooking method for all the fish, steamed fish, nutrients are the best method of preservation, recommended!
Tip one: fish weight control at 600 grams, the volume of this size, placed in the fish dish, looks beautiful, but also raw and cooked a good grasp of the furnace;
Tip two: clean up the fish, the fish spine can be cut off from the abdominal (tail amputated with a knife), to prevent the fish, steamed fish, the fish bone shrinkage leaving the overall deformation, but if you Comparison of strange craft, do not cut the line too, so have not started steaming, put the fish spoil deformation.
clean up the fish after the fish on both sides spread your lard (edible vegetable oil also improvise is), then stained with a little white wine (you can also try to stick some wine, and perhaps also created a new flavor);
Tip three: to about 50 grams of meat mix a little soy sauce, sesame oil, salt, ginger, shiitake mushrooms into the belly of the fish after the end, it can enable more fresh fish, but also prop up the belly of the fish taste so steamed fish body full;
Tip four: take large ginger, cut into uniform to take the longest section of the thin filament beautiful, take the middle of the green onions (Buqingbubai Department, and ginger so long) strips, (for aesthetic to induce loss of appetite) shop in the fish plate, fish the fish into the dish and then sprinkle some onion ginger silk;
Tip Five: Be sure to open water after the steamer, and then the fish wok (do not fish on a steaming pot of cold water, then fall through the. a lot of steamed vegetables are the secret to open, the food went in the water steam);
Tip six: 6-7 minutes to steam off the heat (the furnace is top secret);
Tip seven: off after the fire, do not open the lid, the fish did not pan out, the use of pot Yu Wen vinegar, edible vegetable oil, little salt or no salt) poured over the fish (can not put MSG in order to light, fresh), and then put on a few scattered at random and began to eat parsley before serving.
Features: This tender such as fish, tofu, incense, such as crab meat, light and refreshing. If you eat when there are others here, you want to quietly aligned belly of the fish chopsticks as soon as possible (the most fragrant essence of the most tender place), pre-emptive!
points to add:
1, if it is steamed lotus grass carp and other larger fish or fish (weight should be controlled at 1000 grams), steaming time can be extended by 2-3 minutes, but not too long. Do not forget the
2, can also be a good tune, ready to finally pour in the fish body (soy sauce, vinegar, oil) juice in a small bowl, and steam the fish with the pot, until the fish pan, it will Remove the sauce from the pot, pour in the fish, this sauce compared to the previous raw juice, a little something jerky, fish taste better warm fragrant and soft, suitable for the elderly and those who like the light taste.
3, steaming slightly larger fish, the fish from shelves in the two chopsticks to make a fish out of the chassis overhead, fully exposed to heat the instant the fish, after the pan in the kitchen, quietly withdraw the chopsticks out, do not let Chike find your tips.
4, steaming slightly larger fish, the fish can also be set up (like a fish swimming in the water the way) steam. At this time, can be a saving of 5 cm-long green onions softened belly of the fish, stable and unchanging, so that the fish, put the fish on both sides buckle fixed two small ceramic fish bowl (hold the meat inside the belly of the fish.)
At this point, you can also fish on both sides of each side of the plane in Mito, tool joints in each folder into a ginger. Steamed fish, it will withdraw another small bowl and serve.
Subscribe to:
Posts (Atom)