Handpicked Travel Deals for the Smart Traveler
| 12 Comments

Save Up to 40% Off Weekends at the Grand Hyatt New York

ts_Grand_Hyatt_NY.jpg
The Grand Hyatt New York is offering weekend nights for 20-40% less

A hotel in New York City for under $200 usually means having to compromise on location or comfort (or both). But a new weekend promotion January 3-March 31, 2010 at the Grand Hyatt New York offers up to 40% off rooms and lets you enjoy full hotel amenities (it's primarily a business hotel, after all) and a fantastically convenient location, within walking distance of the Chrysler Building, the New York Public Library, and Rockefeller Center, among others, and it sits virtually on top of Grand Central Station. 

For example, you can book a standard room from Friday, January 15 to Sunday, January 17, for $395 total (including taxes), or $198 per night. Normally, that weekend would cost $510, so you're saving 23%. If you're the kind who likes plush pillows and room service on Valentine's Day, you can do so at the Grand Hyatt for $395 as opposed to $647 from Saturday, February 13 to Monday, February 15. That's 39% you're saving (and $252 could sure buy a nice bottle of bubbly).

Dates: Book by December 23, 2009 for travel from January 3 - March 31, 2010.

How to book: Reserve your room at hyatt.com, writing NYTVLZ in the "Special Offer Code" field, or call 800-233-1234. Again, make sure to mention the Grand Hyatt New York and request the offer code NYTVLZ.


12 Comments

welcome to comment to comment

news

text / correspondent Long Kun, Cui Ningning

informed the meeting: Foshan Red Cross drying accounts

Red Cross: Banks slow to send a single cause misunderstanding

yesterday afternoon, the Shenzhen Red Cross full-time vice president Zhao Lizhen explained that prior to the Shenzhen Red Cross can not tell Zhu Shuxia 100 yuan directed donation is going, because the bank until last month, 28 days before the donation receipt sent to the Shenzhen Red Cross. For all the misunderstanding, the red and the banks have been on July 29 to explain the red witch sword, and sent 3,000 yuan relief funds, in addition to the red will go to help Wu Jiashen 20,000 service workers care fund.

In addition, the Red Cross was held yesterday Foshan City Council, all members of the Tenth Conference and the Red Cross Hospital School of expanding the first meeting of the Board of Directors, announced the Red Cross Hospital, Foshan City, closing schools in the past year Details of donations to the accounts of expenditure and schedule.

microblogging Recommended | microblogging hot today (edit: SN056)

Shenzhen Red Cross yesterday responded that the bank will last until 28 January to send them back to a single, they need to do to get the donation back to a single account to see the contributions of specific purposes, Wu Jianhong was asked contribution matters, the Red Cross was not found, the event is completely a misunderstanding.

buy paper towels, hangers cost 33 yuan,beats by dre pro, donations received in the details and accounts of the breakdown of expenditures, and accounts published yesterday afternoon in Foshan Red Cross website.

question response:

cost of 221,665.62 yuan, balance of 664,772.96 yuan.

Jianhong Wu said, July 16, a woman called and said she donated to the Red Cross's account $ 100, asking Jianhong Wu may have received.

for causing the misunderstanding, the misunderstanding that the Shenzhen Red Cross Zhao Lizhen no accountability,

As to why the donation only after nearly two weeks to get the donation back to the Shenzhen Red Cross alone, according to the related Branch deposit contributions, while 16 and 17 coincides with the weekend, the sales department only received 19 new branches south of the list, but because one day just to send the Red Cross on Pihui so until 28 days before this pen donation receipt sent to the Red Cross.

next day, the woman took the certificate to the Red Cross account deposits to the hospital and handed over to Wu Jianhong. Jianhong Wu said, certificates of deposit with the words of the woman's name is Zhu Shuxia, dated July 15. July 21, Wu Jianhong call Shenzhen Red Cross, said a staff member surnamed Li, has not yet received any contributions.

7 23, Wu Jianhong micro-Bo said, a man named Zhu Shuxia people for donations to provide him with a certificate, but that he call the Red Cross has not received the deposit, a Shenzhen Red Cross is involved in the time vortex of public opinion.

yesterday, in answer to Foshan Red Cross published on the website for the stadium renovation situation, but because of Foshan Red However, if the donation is delivered to the field, Red Cross Hospital School of income and expenditure only the first step yesterday, the sun, from yesterday afternoon from a single running account of the project will publish on-line real-time, future costs incurred to do every day are immediately in the online public.

Foshan newspaper (Reporter Li Qian) in the Chinese Red Cross Society to donate on-line information dissemination platform, after being questioned all parties, executive vice president of the Fan Lihua Foshan Red Cross said yesterday in an interview, Foshan Red Cross since 2004 that published in the online information as well as an endowment for each flow of funds, but details of income and expenditure in local projects and some are staying on the announcement of donations is still not perfect.

donated by the people: $ 100 donation why not find out?

report details the sources of contributions income. In the year 9 donation received, 4 pen personal public donations. Up to a donated two million yuan, is to donate a minimum of 57 yuan. 5 pen business unit contributions, there are two items of 30 million, from Foshan Renshou Temple and Eagle Ceramic Industry (Heyuan Co., Ltd.).

April, Mei County, Guangdong chef Wuchang Kai membership fell ill because of brain stem hemorrhage in Shenzhen, home Despite the expenditure of 400,000 yuan for medical expenses, but still owes the hospital a few million. In early July, his son Wu Jianhong request Shenzhen Red Cross to help the Red Cross to the public account, appeals for contributions.

reporters yesterday that the Industrial Bank of check stubs show, August 1, Industrial Bank has directed this pen 100 yuan Wu Changkai donations transferred Futian District People's Hospital.

report also detailed the school from the Red Cross Hospital of Foshan July 19, 2010 until June 17, 2011 ended 51 breakdown of expenditures.

Foshan Red trip yesterday to catch the sun accounts

the record, at 15:00 on July 15, Zhu Shuxia new branch in the South to the Industrial Bank, Shenzhen Red Cross donation of $ 100 for directed donations Wuchang Kai, and until July 28, the Shenzhen Red Cross will only receive the donation of receipt.

due to a lack of people is not part of the special fund details announced

(Baoliao: Wang prize: $ 100)

Costa has been widowed for 10 years , 12 grandchildren ( female) and 13 great-grandchildren . She insisted no intention to rely on breast augmentation find the U.S. media reported on the 8th , after 5 days of thousands of articles appeared on the network to discuss articles. Some people think she is too flashy vanity of modern society representatives , it was a cool show her appreciation over the spirit of life is never too late .

microblogging Recommended | microblogging hot today ( edit : SN017)

22 last month , living in California Orange County Costa (Marie Kolstad) moved three hours of breast augmentation surgery, spent $ 8,beats by dr dre,000.

eighties But the United States a 83 -year-old children and grandchildren ,

welcome to comment to comment

Work is often to receive some of the Letters, letters, but are usually the name of any national or international academic exchange cover, and to set your Journal, books, shopping and the like spam, Linlin total range of the total pattern magazine fee, conference fees, etc., from several hundred dollars a thousand dollars, or even a few thousand dollars nearly a million, simply dig a pit, waiting for you eager to jump, the contents of letters almost all laser typesetting offset printing things, of course, there are some very few, if the stars a few strokes of the pen the word, is nothing more than write his name, or in which he had published on an unknown publication of a so-called paper name. In any case, only one central theme: you pay, I'll give you honor.
see much more, and not be complacent, and often see such a letter, not even the demolition of demolition, they easily thrown into the trash behind, the only pity is that email's Gongben charges only in less than a second of time has become garbage.
same time, I have always received such Letters, letters of, they will automatically think of those two days of relying on letters to transmit information. Moreover, think of those days, I actually can not remember any case the days of this letter is cut off when the began.
remember when writing the first letter is in fourth grade, my Sanyi Sanyi basking in the public passed away shortly after the return home of Liaoning. Mother when they were young because of asthma, had to leave more hot live in Heilongjiang, Liaoning Puben Sanyi basking, and basking lodging at Sanyi's home, until my sister got married with the following be considered the out of Sanyi grandpa house roof, and a home to buy their own homes. So, whether mother or father, with the Sanyi Sanyi Basking public and have a deep affection. So, when Sanyi less than six months after the public back in Liaoning, then my Mom and Dad sent a letter to write, remember the specific content of the letter, one is always some greetings, take care miss and asked if parents Sanyi public Loved the grounds that I write will become more apparent by the grandson of some kind. Page along with the unique contorted word, filled with greeting greeting, so as a floating sheet of paper, put a penny in an envelope, affix the stamps eight money, shook his way through thousands of fluttering, the fluttering thoughts shook broke into the window.
larger later, my mother often asked me to distant relatives to write letters from home, although those who remember their loved ones are in my impression that people did not, but, each time to write,doudoune moncler pas cher, always so serious, as if those who stood in front of their own loved ones, with their dialogue, even though is strange, there is a warm feeling.
most days of my letter, in spring 1992, when I was a primary term substitute teachers, one of my classmates have been a soldier in that my mailing address, they start to I write, write her feelings in the barracks, her classmates to write miss, write her reverence for truth and friendship. I have every letter she replies carefully, because the two sides are just gate out soon, whether for life or for life, both for the friendship between friends or between lovers love, all have in our hearts too more confused, puzzled, and yearning, longing, then, a soldier in Beijing, she, she sent a letter to a week to receive, and my reply every message will also need a week's time, the In this way, we have nearly a year that almost every two weeks is a letter, come and go, never bored. At this time, I discovered that the original, writing is so interesting, many of them are not involved in daily life can not be involved, then it is entirely possible correspondence with the tireless, but also cynical to speak their minds. Moreover, the correspondence between the parties, can be written in the quiet process, Falling to put pen to paper to listen to the voice of reason heart chaotic thoughts.
the end of 1992, I joined the army a soldier. After military service, I increasingly feel that letter for a person, especially for a stranger's life living in a major. That alone in a foreign land as a stranger feeling, people on family, friends, with endless care and miss.
to force the first thing is the squad leader for the family to write our safe arrival.
when the troops only a fresh, neatly barracks, square-shaped courtyard, neat house, everything is strange, everything is fresh, there is a feeling that you really to grow up, can a person so much a collective life. First letter to the parents say is their safe journey, arrived in all Wunian; with friends and classmates said, is nothing more than those followed by a discourse, to help me take care of my home and my family kind of thing. When the letters sent, they will feel that day is also wide, to have broad, full access to a world left to their own ride.
When all sorts of training in full swing, the kind of full of grievances and no place to feel at once their own dumping of heart block was full, then, desire is the home of the largest letter, and in all correspondence the most hope is their best friend who's letter, because his greatest desire is to read the letter from the spiritual consolation ironing words.
squad who are veterans from recruits over the period, and they of course, to understand each recruit's mind, when the company's correspondent put piles of colorful envelopes sent to the class, the squad leader will be like their home to the letter, as a fief and remembered every envelope mailing address, repeatedly and loudly informed the recipient of each letter of the name, over and over again to ask the recruits want to read each letter, when we answer a resounding Report squad leader, I would like to read letter
in recruits with, no matter who received the letter, everyone in the class of their own home as happy as letters, then hard training, a few melon head would come together, read Le Diandian with, to share the kind of unique happiness.
I do not know that I received a letter in the army comrades in count one of the largest, anyway, in my demobilization occasion, all my letters together, a military satchel stuffed full with my father Mom sent, sent a sister, a friend who sent up, it is the first soldier that my students, we are still in force when the letter of each half, made his comrades know that I There is a soldier of the female students at the Air Force, they are even rumors that we love the news.
In these letters, the most sweet to hear the sister and two friends love marriage news, the most sad is Grandpa passed away received the bad news, the most intimate is the students received the blessing of the happiest the occasion of the annual Chinese New Year can receive all the encouragement and best wishes.
that more than a thousand days and nights, although I miss standing in a foreign land, home and family land, but also in a foreign land, land kept in stationery coerced passion with family, friends, classmates sections Xu Tan. Also at that more than a thousand days and nights, I know why
I do not know since when, the way this pen and paper Xutan quietly from life in 1971, but I do not know when to begin, a variety of communication seemed to have put tens of thousands of people are pulled in ear, dragged the front, letters have become extremely primitive, even disdain to use, but this also makes advanced means of communication between people suddenly become very distant and ethereal, regardless of phone, video on how excited and indulge, but this expression is and the kind of looking forward in hope, in hope of looking after the exhibition in a trembling way memo read over and over again, even stationery pressure in the suboccipital, middle of the night have to get up read with much feeling much different. Previous: Next autumn three kinds of flowers: sweeping chapters

An updating ,Men North Face Jackets, in which fly in the air , always able to carry too much of our dreams.
2011 the advent , the promise of New Year's wishes , by updating the light to find a new road .
today participate in the years , most would like to thank the people
Thunder


Outlook 2011, most want to go
Russia

2011 , the largest wish
500万


I also promised an active desire to

a matter of minutes , so no way out, pretty amazing

( absolutely shocking ! absolutely touched ! This is art !)

share to friends


Author : Xiaohua niu has been sharing 21,979 comments ( 0 ) copy the link to friends Report


for the first time to share those

Share Share 21,979 shares have been from :

Word trick:
First, enter the three , enter the three (WEEKDAY (I3, 2), show week
Excel common functions Daquan

1, ABS function
function name: ABS
main functions: find the absolute value of the corresponding figures.
using the format: ABS (number)
Parameters: number of representatives to request the absolute value or reference cell.
Example: If cell B2 enter the formula: = ABS (A2), in cell A2 enter either positive (such as 100) or negative (eg -100), B2 are shown in the positive (eg, 100).
Special note: If number is not numeric, but some characters (such as A, etc.), then returns the error value B2
2, AND function
function name: AND
main function: Returns the logical value: if all parameters are the logical logical
using the format: AND (logical1, logical2, ...)
Parameter Description: Logical1, Logical2, Logical3 ... ...: that the conditions to be tested value or expression, up to the 30.
Application examples: In cell C5 enter the formula: = AND (A5> = 60, B5> = 60), confirmed. If the C5 return TRUE, shows the value in A5 and B5 are greater than or equal to 60, if you return FALSE, A5 and B5 illustrate at least one value in less than 60.
Special note: If you specify a logical condition parameter contains non-logical value, 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 average value or reference cell (area), not greater than 30.
Application examples: In cell B8, enter the formula: = AVERAGE (B7: D7, F7: H7, 7,8), to confirm, 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 for the cell.
using the format: COLUMN (reference)
Parameters: reference is a reference cell.
Application examples: In cell C11 enter the formula: = COLUMN (B11), confirmation is displayed as 2 (ie, column B).
to remind: If cell B11 enter the formula: = COLUMN (), also shows that 2; Correspondingly, there is a return value of row label function - ROW (reference).
5, CONCATENATE function
function name: CONCATENATE
main functions: the number of characters in the text or data in a cell together, displayed in a cell.
using the format: CONCATENATE (Text1, Text ... ...)
Parameter Description: Text1, Text2 ... ... need to link text or character reference cell.
Application examples: In cell C14 enter the formula: = CONCATENATE (A14 ,character and. com connection as a whole, appears in cell C14.
Special note: If the parameter is not referenced cell, and the text format, please give the English state parameters with double quotes, if the above formula to: = A14 &. com
6, COUNTIF function
function name: COUNTIF
main features: a range of cells that meet specified statistical criteria for 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 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: given the value of the specified date.
using the format: DATE (year, month, day)
Parameters: 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.
Special note: Because of the above formula, for 13 months, more than a month, postponed to January 2004; 35 days, compared with actual number of days in January 2004, the addition of four days, it is also postponed to 2004 February 4, 2010.
8, function name: DATEDIF
main functions: calculate the parameters of the two dates to return the difference.
using the format: = DATEDIF (date1, date2, a date, date2 on behalf of a later date; y (m, d) requires the annual return difference between two dates (month, days).
Application examples: In cell C23 enter the formula: = DATEDIF (A23, TODAY (), , and returns the number of years difference.
Special note: This is a hidden function in Excel, in the Function Wizard is not found, can be used directly for computing age, seniority and other very effective.
9, DAY function
function name: DAY
main functions: find the specified date or the date of the referenced cell the number of days.
using the format: DAY (serial_number)
Parameter Description: serial_number behalf of the specified date or reference cell.
Example: enter the formula: = DAY (
Special note: If the date is given, include double quotation marks in English.
10, DCOUNT function
function name: DCOUNT
main functions: to return a database or list of columns that satisfy 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 marked in the first line item); Criteria include conditions of cells.
Application examples: Figure 1, in cell F4, enter the formula: = DCOUNT (A1: D11, than or equal to 70, while the value is less than 80 the number of cells (equivalent to the number of fractional section).

Special note: If you modify the above formula: = DCOUNT (A1: D11,, F1: G2), can achieve the same purpose.
11, FREQUENCY function
function name: FREQUENCY
main functions: to return to a vertical array 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 represented as an array in front separated by a value.
Application Example: Figure 2, while selected range of cells B32 to B36, enter the formula: = FREQUENCY (B2: B31, D2: D36), enter the complete press key for confirmation, you can find the B2 to B31 area, according to area D2 to D36 paragraphs separated the number of frequency values ​​(equivalent to the number of statistical segments of the score).

Special note: The input is an array formula, you're finished, need to press ({}), the braces can not be directly input.
12, IF function
function name: IF
main functions: logic based on specified criteria to determine the true and false results, return the corresponding content.
using the format: = IF (Logical, Value_if_true, Value_if_false)
Parameter Description: Logical behalf of logic expressions; Value_if_true conditions that determine when a logic TRUE
Application examples: In C29 enter the formula in a cell: = IF (C26> = 18, the C29 cell shows
Special note: this article, similar to the the appropriate 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 values, 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, you must have column_num); Column_num that 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), confirmation is displayed in a range of cells A1 to D11, and line 4 3 cell at the intersection (ie, C4) in the content.

Special note: here's the line number parameter (row_num) and column number parameter (column_num) is the range of cells relative to the terms of reference, not an Excel worksheet rows or columns in the order number.
14, INT function
function name: INT
main functions: the value rounded down to the nearest whole number.
using the format: INT (number)
Parameters: number expressed the need for rounding numeric values ​​or contains a reference to cell.
Example: enter the formula: = INT (18.89), confirmed show 18.
remind: when in the rounded, without rounding; If you enter the formula = INT (-18.89), then returns the result of -19.

15, ISERROR function
function name: ISERROR
main functions: used to test the functional return value for errors. If there is an error 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), recognized, if the B35 cell is empty or
Special note: This function is typically used with the IF function matching, if the above formula changes to: = IF (ISERROR (A35/B35 ),shows the corresponding cell is 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 to be cut on behalf of the character string; num_chars interception on behalf of a given number.
Example: assume that A38 cells to save the characters.
remind: 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)
Parameters: text, said text string to statistics.
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 mode value matches the specified array of elements in the corresponding 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).
If match_type is -1, greater than or equal to lookup_value find minimum value, Lookup_array must be sorted in descending order;
If match_type is 1, less than or equal to lookup_value find the maximum value, Lookup_array must be in ascending order ;
If match_type is 0, find the first value equal to lookup_value, Lookup_array can be arranged in any order; if omitted match_type, the default is 1.
Application examples: as shown in Figure 4, in cell F2 enter the formula: = MATCH (E2, B1: B11, 0), confirmed the results returned to find

remind: Lookup_array only for a column or row.
19, MAX function
function name: MAX
main functions: find a set number of maximum.
using the format: MAX (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the maximum value or the reference cell (area), not greater than 30.
Example: enter the formula: = MAX (E44: J44, 7,8,9,10), confirmed to display the E44 to J44 cells and in the region and the maximum value 7,8,9,10 .
Special note: If the parameters are text or logical values, it is ignored.
20, MID function
function name: MID
main functions: the text string from a specified location, 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 the specified starting position; num_chars indicated that the number of intercepts.
Example: assume that A47 cells to save the
remind: the formula of the parameters, the use of the English state comma
21, MIN function
function name: MIN
main functions: find a set number of minimum.
using the format: MIN (number1, number2 ... ...)
Parameter Description: number1, number2 ... ... representatives to request the minimum reference value or a cell (area), not greater than 30.
Example: enter the formula: = MIN (E44: J44, 7,8,9,10), confirmed to display the E44 to J44 cells and in the region and the minimum value 7,8,9,10 .
Special note: If the parameters are text or logical values, it is ignored.
22, MOD function
function name: MOD
main functions: find two numbers divided by the remainder.
using the format: MOD (number, divisor)
Parameters: number representative of the dividend; divisor on behalf of the divisor.
Example: enter the formula: = MOD (13,4), confirmed the results show
to remind: If divisor parameter is zero, an error value .
23, MONTH function
function name: MONTH
main functions: find the specified date or the date of the referenced cell the month.
using the format: MONTH (serial_number)
Parameter Description: serial_number behalf of the specified date or reference cell.
Example: enter the formula: = MONTH (
Special note: If the date is given, include double quotation marks in English; if you modify the above 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 requires no arguments.
Example: enter the formula: = NOW (), immediately after the show to confirm the current system date and time. If the system date and time has changed, just click the F9 function key, you can let it change.
Special note: the date and time display format, cell formatting can be reset.
25, OR function
function name: OR
main function: Returns the logical value, only if all parameter values ​​are logical otherwise returns logical
using the format: OR (logical1, logical2, ...) Parameters: Logical1, Logical2, Logical3 ... ...: that the conditions to be tested value or expression, up to the 30.
Application examples: the cell enter the formula in C62: = OR (A62> = 60, B62> = 60), confirmed. If C62 is returned TRUE, shows the value of A62 and B62 in at least one greater than or equal to 60, if the returns FALSE, A62 and B62 in the description of the values ​​are less than 60.
Special note: If you specify a logical condition parameter contains non-logical value, the function returns the error value
26, RANK function
function name: RANK
main functions: to return a value in a value relative to other values ​​in the ranking.
using the format: RANK (Number, ref, order)
Parameter Description: Number on behalf of the values ​​to be sorted; ref on behalf of a range of cells in which the sort value; order on behalf of sort parameters (if ignored, according to descending rank, that is, the greater the value, ranking the results with smaller values; if other than
Application example: If in cell C2 enter the formula: = RANK (B2, $ B $ 2: $ B $ 31,0), confirmed the students can come to the small one in the class scores in language performance ranking results.
remind: In the above formula, we make reference to the Number parameter to a relative form, and let the ref parameter to the absolute reference form (add a mouse over the lower right corner of the cell, into thin cross-linear (usually called the complete ranking scores of other students of language statistics.
27, RIGHT function
function name: RIGHT
main functions: a text string from the last character, the interception of a specified number of characters.
using the format: RIGHT (text, num_chars)
Parameter Description: text to be cut on behalf of the character string; num_chars interception on behalf of a given number.
Example: assume that A65 cells to save the characters.
remind: Num_chars parameter must be greater than or equal to 0, if omitted, its default is 1; If num_chars parameter is greater than 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 in the subtotals.
using the format: SUBTOTAL (function_num, ref1, ref2, ...) Parameters: Function_num 1 to 11 (includes hidden values) or 101 to 111 (ignores hidden values) between the numbers used to specify what function in calculating subtotals within a list (Figure 6); ref1, ref2, ... ... on behalf of the region you want to subtotal or references, no more than 29.
Application Example: Figure 7 shows, in the B64 and C64 cells, respectively, enter the formula: = SUBTOTAL (3, C2: C63) and = SUBTOTAL103, C2: C63), and will hide the line 61, after confirmation The former is displayed as 62 (including hidden lines), which appears as 61, not including the hidden rows.


Special note: If you take automated screening, no matter what type function_num parameter selection, SUBTOTAL function ignores any screening results are not included in the line; SUBTOTAL function or vertical columns of data for the region, does not apply to data line or level area.
29, function name: SUM
main functions: calculate all the parameters and values.
using the format: SUM (Number1, Number2 ... ...)
Parameter Description: Number1, Number2 ... ... representatives need to calculate the value that can be of specific value, a reference cell (area), logical values.
Application Example: Figure 7 shows, in cell D64 enter the formula: = SUM (D2: D63), confirmation can be obtained language scores.
to remind: If parameter is an array or reference, only one of the figures will be calculated. Array or reference empty cells, logical values, text or error values ​​are ignored; if you modify the above 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: calculate the range of cells that meet specified criteria and the value.
using the format: SUMIF (Range, Criteria, Sum_Range)
Parameter Description: Range on behalf of the conditions to determine the range of cells; Criteria for the specified conditional expression; Sum_Range need to calculate the value representative of where the range of cells.
Application Example: Figure 7 shows, in cell D64 enter the formula: = SUMIF (C2: C63, .
Special note: If you modify the above formula is: = SUMIF (C2: C63, Because it is text-based, needs to be placed under the state's English double quotes (
31, TEXT function
function name: TEXT
main functions: According to the format specified by the corresponding digital value converted to text.
using the format: TEXT (value, format_text)
Parameters: value representative of the value or need to convert the cell references; format_text text form for the specified number format.
Example: If the B68 cell preservation value 1280.45, the cells in C68 enter the formula: = TEXT (B68,
remind: 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 requires no arguments.
Example: enter the formula: = TODAY (), immediately after the show to confirm the system date and time. If the system date and time has changed, just click the F9 function key, you can let it change.
Special note: The date display format, you can re-set the cell formatting (see Annex).
33, VALUE function
function name: VALUE
main functions: the value of a representative text string into a 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 the LEFT and other text-based string in cell C74 enter the formula: = VALUE (B74), to confirm, you can convert it to numeric.
Special note: If the text type value without the conversion, in these values ​​when dealing with functions often return an 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 one range of cells; Col_index_num in the area to be returned table_array match the value of the column number (when Col_index_num = 2, column 2 table_array returned values ​​of 3, the return value of the first three ... ...); Range_lookup is a logical value, if it is TRUE or omitted, returns approximate match, that is, if not find an exact match, it returns the maximum value is less than lookup_value; if FALSE, then return exact match, if found, return an error value # N / A.
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 small 48), D65 cells showed immediate results of the student's language.
remind: Lookup_value see Table_array area must be the first column; if ignored Range_lookup parameters, Table_array the first column must be sorted; in this function wizard, use the Range_lookup argument is wrong.
35, WEEKDAY function
function name: WEEKDAY
main functions: the specified date given in the corresponding number of weeks.
using the format: WEEKDAY (serial_number, return_type)
Parameter Description: serial_number behalf of the specified date or dates of that contains the cell references; return_type representation on behalf of week [when the Sunday (Sunday) to 1, Saturday (Saturday ) 7, this parameter is 1; when Monday (Monday) 1, Sunday (Sunday) to 7, this parameter is 2 (this is in line with the Chinese people's habits); When Monday (Monday) 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.
Special note: If the specified date, please state on the English double quotes, such as = WEEKDAY (
one. Select color effect cell form, format - conditional formatting, conditions, select the


1. interlacing color effect (odd row colors):
= MOD (ROW (), 2) = 1
2. interlacing color effect (even row color): = MOD (ROW (), 2) = 0
3. If you want to set the format is applied once every 3 line shading, use the formula:
= MOD (ROW (), 3) = 1 4. If you want to set out a different shading parity, as long as the formula of the ROW () to COLUMN () can, such as:
= MOD (COLUMN (), 2)
5. If you want to set 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 do not fill. In the Conditional Formatting, the formula returns a numeric result, the non-zero number is TRUE, 0, and the error value is FALSE. Therefore, the above formula can also be written as:
= MOD (ROW () + COLUMN (), 2) > 0
6. If you want to set up chess checkerboard shading (custom colors + custom color):
adding style 2:
= MOD (ROW () + COLUMN (), 2) = 0
two. Color filter
excel2007 can by cell color, font color, or icon to sort.
If the excel2003, need to add auxiliary column, with the defined name to get the corresponding color number, and then sort of supporting columns:
color cell in column A, select B1, Insert -> Name - > Define, enter a, enter the formula = get.cell (24, $ a1),
this method obtained 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 the serial number to get the background color will change 63 to 24.
== into a name 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, Num is specified to obtain the kind of information, this function is to allow 24 units of color information removed, taken out after a 1-56 figure of a certain color number
3. B1 column if you enter your name and the definition of fill, then A1 B1 in the figure is 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, according to color sort column A the.
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 TYPE function
5 with reference to the text contents of the address
6 shows the light formula
7 address address reference format, the text display text display
8 format
9 with reference to the address returned extra storage box left style, figures show
10 return save extra box on the right style, figures show
11 return save extra box on the style side, digital display
12 return extra storage box under the square style, digital Returns the internal display
13 drawings, digital display
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 for the unit returned to the cell height
18 point font name
19 to return the font size for the unit cell
20 if all or the first character bold return True
21 If all or a cell for the first character italic return True
22 If all or a cell first character is a single bottom-line returns True
23 if the cell or the first character fonts for all the middle of a horizontal line return True
24 returns the first character color cell number, 1-56. If set to Auto, return 0
25 MS Excel does not support the outline format
26 MS Excel does not support the shadow format
27 figures set manually inserted page breaks out the outline
28 level
29 column outline level
30 if the range is a summary outline of the column was 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 format for multi-line text was returned True
34 extra storage box on the left color digital display. If set to Auto, return 0
35 return save extra box on the right color, digital display. If set to Auto, return 0
36 return extra storage box above the color digital display. If set to Auto, return 0
37 return save extra box below the color digital display. If set to Auto, return 0
38 returns the cell foreground color shadows, figures show. If set to Auto, return 0
39 returns the cell back color shadows, figures show. If set to Auto, the text returned 0
40 shows the cell reference style
41 return address of the original formula
42 in points in the window using the left returned to the level of the cell on the left distance
43 in points, return to the top of the window using the vertical distance above the cell
44 in points, returns the window on the left to use the cell to the right horizontal distance
45 points unit returns to the top of the window using the vertical distance between the bottom of the cell if the cell has
46 comments returned insert True
47 if the cell has to insert a sound prompt return True
48 into the formula if the cell has return True
49 if the cell is an array formula returns the range of returns True
50 cell vertical alignment, digital display
51 cell vertical return, figures show
52 pass back to the cell prefix character
53 text display the returned content
54 cell displays the cell returns the name of the PivotTable cell
55 returns the position in the pivot table pivot
56 57 or if all cells for the first character superscript return True
58 returns the cell text show the first characters of all or font style
59 returns the cell bottom line style, digital display 60 If all or a cell for the first character subscript return True
61 pivot
62 shows the workbook and worksheet name
63 returns the cell's fill color
64 pass back to the drawing foreground color
65 pivot
66 shows the name of the workbook


finally we have to praise the Chinese people, fearing neither hardship nor death indomitable spirit , Euler , we worked hard,north face down jacket!


has not got under the determination to the Expo , or actually go , the mighty 40 -strong team set off on this .

fact, the choice is really a good time , just after the Mid-Autumn Festival , National Day ago, so the flow of people throughout the park some time ago less than half , and the value of autumn, so it seems a whole lot better than the summer , people do not feel so tired , but really come a day exhausted , but fortunately a colleague of supervision, and hard work will be persevered .


Unconsciously , has come to bid farewell to my college career , when , and tomorrow will usher in my last university exam . Memories of the past few years come to my eyes instantly . My university , there are smiles , there are tears , more sweat ~ , there is the joy of success , but also occasionally failed in my heart of suffering . Fame on the surface of how much bitterness I actually do ? I guess no one of these in addition to know ~ ! Put a smile to show to others , the pains in my heart it! ! Have been already become history , once lost may also be able to have again , no amount of twists and turns have passed, and soon I will usher in my life the most important turning point , I believe I will be like before Instinct life, at least in front of my friends who ~ ~ ! ,north face down jacket!

Small Shenyang version IT work: in fact, the computer can be hard to do sometimes think : the goods entering and exiting , one day later, howl !
goods entered , no ,dr dre studio, another day passed howl ! !
you know the most painful thing is? That is not the goods , the customer orders it!
you know that most pain is? With goods , the customer uncertain it!
that you know both are painful than what is it? That order , and then return it! ... ...
Sometimes one would like, shipping is the same the same: a dozen calls a hanging , a goods sent out, and howl ; phones not linked to a dozen , certainly did not solve the sale !
the most painful thing in life you know what that is?
the goods made ​​, the money was received



Episode



Revenue more than a spare tire, more of a living! ECosway is a great grass-roots entrepreneurial career opportunity! In understanding the process, have any questions, please feel free to communicate with us. Business Exchange QQ: 1285092337

first episode



Episode III




Zhai Hong: Beijing fulcrum of future advanced training management consulting firm Distinguished Lecturer of Chinese marketing, real trainers, scientists Guoxue practical application, economic and cultural scholars, visiting professor at Peking University. Ngong Road, the current chairman of the International Group, China International Talent Dean of Engineering, DAM president of marketing development agencies, entrepreneurial training center director of Peking University, China, China Business expert advisory chief adviser, Professor Emeritus, University of the US National doctoral tutor in recent years, Prof. Zhai at all levels of government, has done thousands of well-known institutions market various forms of education and training, lectures, so that nearly a million people in the consciousness after the shock and get thinking, behavior and mentality of a breakthrough, known as the China of today's most valuable education, training experts.
Traditional Chinese culture advocates and communicators. Over the years, Professor Zhai has always entertained a strong national commitment to the heart and mission and philosophy of traditional Chinese culture research, integrate a variety of great international representative of the philosophy of mainstream marketing theory, combined with China's actual situation, for management science, decision sciences, personnel training, marketing, corporate teams and other aspects of a set of unique solutions, and has aroused great repercussion in the academic community.
developed by Professor David Zhai famous in Tsinghua University, Renmin University of China, Beijing University of Technology, National University of the United States and other renowned institutions of MBA, EMBA, DBA, excellent leadership training programs and other popular classes.
Prof. Zhai recent years in various level of government, has done thousands of well-known institutions of various forms of education and training field and lectures, so that nearly a million people to gain awareness in the shock and mental growth and breakthrough.
Professor Zhai Hong-selling monograph: before the peak group, Yutong Group, etc. more of a number of small and medium enterprises are being developed, such as the Silver Man's, Xie Rui company, etc. These companies are in Professor Zhai witnessed its corporate culture, team building, corporate internal staff training and dealers throughout the country, after agents received training and vigor in the country has thousands of short chain, the annual turnover exceeded billion!
; Professor Zhai continue to explore China's road to training, self-build Godfather Taoism, Tsinghua University, Renmin University, Beijing University of Technology Distinguished Professor, State University Distinguished American doctoral tutor. Zhai professor has been committed to carry forward the Chinese traditional culture, was invited at all levels of government, well-known institutions, the business classes, lectures, the consciousness of millions of people get shocked and thinking, behavior, attitude breakthrough. Zhai, organized by Prof. merit class convey

episode

one on self cultivation

★ phase from the heart, change the internal, in order to change the face. Care can not afford a dark heart a bright face. There must be harmony of love; the gas must Discovery color; the color must Discovery Shirley.
★ mouth is the gateway to the heart. Mouth the words to say, on behalf of my heart to do. Heart and mouth are the same.
★ a low level of people, could not speak lofty words; a person without a sense of mission, could not speak responsible words; a pattern of small people, do not speak if the atmosphere.
★ companies compete with the business end, the entrepreneur mind competition, state competition.
★ dislike to see other people, their training is not enough.
★ a grace only Germany, there are moral and blessed, and this is an old saying of
★ person's life is the Dao,north face fleece outlet, enlightenment, and finally the process of enlightenment.
★ good - is no time for people who do bad things.
★ flow to the same exchanges of views in order to pledge allegiance, pledge allegiance to the transaction .
★ equal with the flow convergence, convergence is equal to Hexin, Hexin equal to ingratiate themselves.

Second, on the success

★ To be successful we must first learn to - change of mind, status and attitudes.
★ success = thinking × × expressive power of action.
★ many unsuccessful not because no action plan before the plan but the lack of previous action.
★ BES power is power, future generations benefit is the benefit, name is Jesus Christ name.

Third, on the team

★ What is the team to see the word you know, articulate group of people against people who speak the ear, this is the team.

four, on the communication

★ communication must be conducted in the right, is thinking, right speech, right effort, mindfulness of departure, in order to achieve consistent and effective cooperation. Communication between the Chinese people always start from home.
★ High-quality communication, should focus on results, rather than emotional, communication from the heart.
★ communication has three elements: the written language, audio language, body language. Written language to convey information, voice language to convey feelings, body language to convey attitude.
★ affect communication effectiveness has three elements: situation, atmosphere and mood.
★ communicate three characteristics: the behavior of the initiative, the process of interaction, the diversity of objects.
★ communicate five basic steps: nod, smile, listen, respond, take notes.
★ five heart of communication: the joy of the heart, generous heart, empathy, praise the heart, love.
★ emotional communication is the transfer, the transfer of information, emotional interaction. Communication is no right or wrong, only the position.
★ interpersonal communication , the most taboo is look lifeless. To learn Smile can change themselves, to give people the power of laughter, laughter can create a good atmosphere, laughter can bring people joy, laughter is the ladder of success.

V .

★ gains and losses in order to bear down, give up to get. How much heart, the stage is as big. In the words of Emperor Qianlong once put ass up, face the audience and on the red ; Qianlong very happy, and the ministers thought it was put; and it will be for the emperor, trust. 200 years later the day, the Secretary and the Secretary to accompany the mayor to attend a Council, in the elevator, the mayor has put the ass are not careful, to alleviate the, the Secretary of the running out of patience, explaining that The next day, put the secretary to the mayor resigned, Secretary of the difficulty, the mayor said: Ah fart bigger things are can not bear to stay you use?
★ killing is to release, to eat meat in order to plant release.

six, on talents

★ length of employment, there is nothing without the people, employing short, the world is no available person.
★ talent does not necessarily articulate and eloquent person, but there must be talent. In the United States who speak, who will be president who is eloquent.
★ pregnant and the pregnancy is the same as before, as long as there, sooner or later will be seen. Was underappreciated because pregnant was not big enough.

7, on learning and growing

★ knowledge is learned, the ability out of practice, the mind is to repair.
★ afraid they begin, feel afraid later.
★ we do not blink to spend three: do not blink to spend caring for the elderly; as buddies to spend money without blinking; to grow and learn money does not blink.
★ Mao Zedong said that the purpose is to apply master. Knowledge is not power, but the use of knowledge is power.
★ Mao Zedong said, three days without learning to keep up with comrade Liu Shaoqi.
★ less than someone else, that is, the value of their own existence.
★ thinking a million power source,
★ a mental model is not good, it is easy to knowledge of more and more reactionary.
★ person can not become a major event, because too few friends, friends, quality is not high.
★ verses into mind you, that you give yourself the opening.
★ The best place to invest, over the neck. How many of our people regard the money in the life of the neck.

you
you the
you
you
★ understand the traditional culture, a manager can become worth hundreds of millions of the rich, but will never become a true entrepreneur.
★ spend more time growing their own, few take the time to blame others envy;
★ If you think in life, like the best way is to change the fate of the lucky people to find friends.
★ 08 years later who did not speak Chinese on the particular grade, and in 2008, when English is to Chinese torture, and the Olympic Games began, the announcer have to change all Chinese way. I learn a foreign language is to teach foreigners to learn Chinese, to see the foreigner do not say: I'm sorry, my English is not good, the first thing to say: Hello, you Chinese?

8, on the wise and foolish

★ most stupid people, that is good do not need to complete the dry matter.
★ understand people are smart, know their is wisdom.
★ If a bad attitude, then it is easy to s wisdom wrong.

nine, on filial piety
★ no notice of small, medium and Koji enterprises, large Xiao country.
★ tomorrow Road, a humane, open the business channel, to bring harmony to your life.
★ planted a good side, reap a conscience; planted a conscience, a moral harvest; planted a moral, reap a habit; species Under a habit, reap a character; planted a character, reap a way of life.

10, on marketing

★ sales is not selling, is to help customers buy.
★ All the marketing in China can be a word
★ only marketing to corporate profits, the other is the cost, companies do not know the biggest cost is marketing staff.
★ allow customers to continuously identify you, you will be successful.
★ customers not only care about who you are, he is more concerned about what benefits you can give him.
★ customers do not reject the product, he is not a denial of service, he just refused to mediocrity.
★ refusal is a kind of inertia, when a customer refuses to us, our work has only just begun XI, about money and wealth

★ Do not live backwards, life itself is wealth.
; ★ financial scattered people together, to lion.
★ money is only one purpose: to spend. less money, home, and more, is everyone, more, that is, the people, so called the yuan.
★ said there was no time and space of the old people, these people are the poorest people, the most stupid people know that the money in the bank, the bank is to people who do not love to spend the money and brought it to the people who love to spend money to spend.

ten Second, on tea and wine

★ Banqiao said: wine can be chaotic, and so was Fojie it. wine can raise, which is why drinking Xianjia of, so when there is wine Buddhist, did not learn when the wine fairy.
★ lofty Red three glasses of wine , Qianqiutaiye a pot of tea.

XIII other

★ Mao Zedong said: investigation as a pregnant woman, to solve the problem Like one day delivery. no investigation, no right to speak. ★ not so many people disturb me, how do I value players! - Maradona.
★ generous heart, that is, personnel director, will be guest, the short.
★ empathy, know how to recognize others , stand in someone else's position. there is no communication between right and wrong, but the position is different.
★ praise the heart, praise is the lubricant of interpersonal communication, Praise allow others to continue to do the right thing. ★ The fairy tale is: Zhai Hong-profile




Episode IV




Di Liuji




The toll in a hospital, a 7,8-year-old girl accompanied his father in the queue to make payments, the little girl holding a bag of milk. Suddenly, she accidentally fell to the ground soy milk, soy milk spilled over the floor. The little girl's father immediately fly into a rage, his mouth to curse: clothes, what to do.
In fact, children growing up, children make mistakes is normal. The face of the child's errors, if parents pay attention to education, regardless of indiscriminate criticism, blame, punishment, not only can not let the children correct the error, on the contrary the child will form a timid, withdrawn or rebellious, attacks and other adverse psychological. Therefore, when children make mistakes, parents should learn to treat the child's errors, specifically, from the following aspects:
1, children learn to be tolerant of errors.
people err not over. In life, sometimes adults are bound to appear this kind of error, let alone the worldly children. So, faced with the child's error, parents should first be treated with a sense of balance, as it is a normal phenomenon, a child growing inevitable. Second, parents must learn to control anger. Sometimes a child will make mistakes parents hit the roof, the children beat a meal, the problem is even if you do hit a child, can not serve the purpose of educating the children, the opposite may let the children learn from their parents to use So the system is that all parents of anger, Third, parents should calmly to the child to reason, to help children analyze mistake, and that the correct approach. If the parents the child's error tolerance, then the child will learn to be tolerant of others, this is what a valuable quality ah.
2, distinguish between the child's error.
error into the child's accidental errors and subjective errors. The so-called accidental errors are generally due to child unintentional or inadvertent mistakes, as mentioned above, the little girl accidentally spilled milk. Treatment of such errors, parents should forgive, tolerance children, and helping children to analyze and solve problems. The so-called subjective errors, mainly refers to children caused by the intentional or misjudgments, mistakes, such as taking the other things, a practical joke, and so on. The main reason children commit such errors is to get attention, lack of self-pleasure and self-concept of right and wrong, do not know their behavior is wrong. Treatment of such errors, serious parents must give children clear mistake and harm, and to supervise their children correct. No matter what kind of errors children made, parents should not avoid arbitrary beats a child, or easy to make back the child to rebellious, or psychological.
3, give the child a chance to explain.
some parents anxious temper especially when children make mistakes, do not give children the time and opportunity to explain, to say the first child maltreatment meal. In fact, parents this is very selfish, beats a child just to vent their anger, relieve their emotions, did not achieve the aim of education. Sometimes kids make mistakes is not out of intention, but to help parents to do something, just because of their ability to not only experience and mistakes. For example there is a little girl wanted to help parents wash,monster beats by dr dre headphones, do not break the bowl carefully. If parents do not listen to children explain and hit the child, the result is a blow to the enthusiasm of a child, after the child no longer help the parents at work.
4, to teach the children learn self-education.
Sometimes children unintentionally made a mistake, not criticisms of education such as parents, that he has began to regret, reflection, self-educated. Therefore, when children make mistakes, parents can guide children to find their own reasons and be corrected, so that the child of their own mistakes will be more profound understanding of consciousness to correct the error will be higher, or do not make the future will be less committed similar errors. For instance, some students do math problems often copied the wrong line, if the child is able to recognize their own sloppy caused by careless, then the child will be more aware of the problems to correct careless.
In short, the face of the child's error, if the parents simply criticize, blame is no education effect, on the contrary will be the child's psychological adverse effects. The correct approach is to treat the child's parents to learn the error, the error as an opportunity to educate their children, so that children continue to grow up to correct the error.

Intelligence: 145

battle Index: 15000

Who: Aoba Rui is five hundred and seven (i) (i) three to help veteran, is a long road superior magic, his magic skills at the time almost invincible (except for his master, Zhang Zhen), the Road although not as often planned Xie large Kua important actions, but each will encounter magic opponents, will need to get him to run for. His brother is re-power, his real power is much larger than the old paradigm and the old boast.

Name: beam bare


character description: super-abilities with the old light, have always been wrapped in bandages, his forehead down to the next person,beats by dr dre headphones, countless. A move to poke its nose was bloodied arena, and since then retreated into the shadows. A force after several visits to carry a lot of books, gifts, before coming out to help.

Intelligence: 160


positions: military commanders


positions: right hand

Name: Xie large Kua


Name: Ali

file number: 1



battle Index: 8000 Note: (18000 fighting to destroy the earth)


Title: pool of eight to ride the tiger boss and Pioneer make

gang circles in the world has been circulating such a legend.

in the Far East has a code for I do not know how many scholars to spend a whole lifetime to study the gang are just about scratched the surface. Ever since I heard the United States after a specialized agency organized to collect their traces everywhere, it took nearly 300 years and finally found the secret of this amazing community. First published under the key members of the gang.

file number: 6


positions: the main fact

Name: Aoba Rui


File No.: 7


Intelligence: 180

Name: Lu white

positions: left hand

Intelligence: 190


file number: 3

battle Index:> 10000 (with the weather affected)

Intelligence: 160

File No.: 4


Intelligence: 100

positions: Logistics Commander




characters introduced: known as Strong, brave, is five hundred and seven (i) (i) three to help one of the best home here. Legend is the only daughter of a country by its own security men. 356 round battle with Aoba Rui was neck and neck, and finally suspended due to weather duel!

Intelligence: 275

Who: skillful, called Good living doing hand sewing, Feizhenzouxian, skilled. Love to get the gun stick. In particular stunt Shao Gong, Shao film invincible hand, be a must.

Name: Fan kegs

battle Index: 0

battle Index: 12000


Who: Big Spender had a good one, Nantong, and Kua brother by force do a bereaved brother, forced to become a gang leader. Brother to Brother drum occupation force is to raise five hundred and seven (i) (i) three to help the know that even the famous Van kegs are our people! Fan people do with the old martial arts, invincible, and shot the Tigers captured the Great Bear, so when the deputy leader of the old paradigm, the brothers are still very clothing.


Name: Zhang Meili

characters introduced: into to help before the baby on the country shocked the world single-handedly engineered the robbery case of Pirates of the Caribbean, a famous boast. Since Xie large Kua into the help, the cunning Xie large Kua immediately into the arms of Ali, Ali became the most effective think tanks, planning a series of five hundred and seven (i) (i) The three major actions. So thank big Kua when five hundred and seven (i) (i) three absolutely logical second in command, but five hundred and seven (i) (i) three kegs need this flagship range, Xie large Kua is also ranked No. 3 had a.


battle Index: 16000

file number: 2


Who: Columbia rivers and lakes known as force, is one of the gang's most mysterious figures, some people say when Napoleon in May 1802 had been to visit several times, then he returned home after eight years to modify the Republican Constitution, to life in power. Resourceful, the rage in the arena, a large group of hardcore brothers, and his seat is definitely the main fact sit tight.


battle Index: 4000

file number: 5


continued ,,,

Title: pool of eight tiger riding a second child


Leave a comment

About Deal of the Day

The deals featured here have been rigorously scrutinized by Wendy Perrin and Paul Brady. We've done the math for you, adding in the hidden charges—taxes and all mandatory fees—so that you don't have to. Remember, it’s not a real deal until we say it is.