{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel function application function of the date and time detailed tutorial (with examples)
Finishing by: Date:2009-04-11 12:45:05 Popularity: Tags:tutorial


example: a simple and beautiful form of personnel data analysis

1, an example of the

as shown in Figure 6 of a company and personnel data sheets, in addition to numbers, staff names, identity card numbers as well as the insertion of working hours for the manual, the rest of the function are calculated.


Figure 6

in this case a detailed account of how we will be obtained through the function :

(1) automatically extracted from the identity card number date of birth, gender information.

(2) automatically from time to participate in the work of extracting information service.

2, identity card number of the relevant knowledge to understand how

automatically extracted from the identity card number date of birth, gender, prior information, first of all need to be aware of the identity card numbers represented by meaning. We know that today's identity card number of the sub-spaces are 15/18. Identity card number issued in the early 15's is now issuing an identity card as a result of the expansion year (from two to four) and at the end of the addition of well-tested code, it becomes 18. Identity card numbers of both will be quite a long period of coexistence. The meaning of two types of identity card numbers are as follows:

(1) 15-bit ID number: 1 ~ 6 for the area code, 7 to 8 for the year of birth (2), 9 ~ 10 place for the month of birth, 11 to 12 for date of birth, the first 13 to No. 15 for the order and be able to determine the sex, odd for men, even for women.

(2) 18-bit ID number: 1 ~ 6 for the area code, 7 to 10 for year of birth (4), 11 ~ 12 for the month of birth, 13 ~ 14 for date of birth, the first 15 to No. 17 for the order and be able to determine the sex, odd for men, even for women. Well-tested for 18-bit.
there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1