CN109062878A - A kind of generation method and device of table - Google Patents

A kind of generation method and device of table Download PDF

Info

Publication number
CN109062878A
CN109062878A CN201810681692.9A CN201810681692A CN109062878A CN 109062878 A CN109062878 A CN 109062878A CN 201810681692 A CN201810681692 A CN 201810681692A CN 109062878 A CN109062878 A CN 109062878A
Authority
CN
China
Prior art keywords
office worker
date
registration
column
hiring
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201810681692.9A
Other languages
Chinese (zh)
Inventor
张勇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Individual
Original Assignee
Individual
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Individual filed Critical Individual
Priority to CN201810681692.9A priority Critical patent/CN109062878A/en
Publication of CN109062878A publication Critical patent/CN109062878A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/177Editing, e.g. inserting or deleting of tables; using ruled lines
    • G06F40/18Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/183Tabulation, i.e. one-dimensional positioning
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/10Office automation; Time management
    • G06Q10/105Human resources
    • G06Q10/1053Employment or hiring

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Human Resources & Organizations (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • General Engineering & Computer Science (AREA)
  • General Health & Medical Sciences (AREA)
  • Computational Linguistics (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Strategic Management (AREA)
  • General Business, Economics & Management (AREA)
  • Data Mining & Analysis (AREA)
  • Marketing (AREA)
  • Economics (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Operations Research (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

This application discloses a kind of generation method of table and devices, this method comprises: counting position level, hiring date, year of birth, name, post title and the head portrait picture of each office worker in specific office;With preset position level be column, with the hiring date of each office worker be row establish table;According to the position level and hiring date of each office worker, the year of birth of each office worker, name, post title and head portrait picture are added on the corresponding position in the table, intuitively each office worker in a department can be analyzed by the table of above-mentioned generation and personnel information counts.

Description

A kind of generation method and device of table
Technical field
This application involves field of computer technology, in particular to the generation method and device of a kind of table.
Background technique
In a company, what personnel information was usually counted as unit of department, Fig. 1 is one kind in the prior art The schematic diagram of table, as shown in Figure 1, the table is the personnel information of Finance Department, which only carries out letter for personnel information Single enumerates, and can not intuitively be analyzed personnel information by table shown in FIG. 1, for example, cannot determine faster The data such as the personnel of a certain time registration and number.
Summary of the invention
The main purpose of the application is to provide the generation method and device of a kind of table, so as to intuitively to office worker Information is analyzed.
To achieve the goals above, this application provides a kind of table generation methods, which comprises
Count position level, hiring date, year of birth, name, post title and the head portrait of each office worker in specific office Picture;
With preset position level be column, with the hiring date of each office worker be row establish table;
According to the position level and hiring date of each office worker, by the year of birth of each office worker, name, post title and head portrait Picture is added on the corresponding position in the table.
Optionally, the hiring date includes: registration time and registration date;
It is described with preset position level be column, with the hiring date of each office worker be row establish table, comprising:
It is column using preset position level, using the registration time of each office worker is as the first row, with the registration date of each office worker Second row establishes the table;
Wherein, in a column direction, the registration date of each office worker is correspondingly arranged with the registration time of the office worker;
The column on the registration date with the identical registration time constitutes a column.
Optionally, the registration date in a column successively arranges according to the sequencing of time.
Optionally, the table further include:
Registration time demographics row;
The method also includes:
According to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes the first sequence Number;
First serial number is added to corresponding with the registration date in the column in the registration time demographics row On position.
Optionally, the table further include:
Total number of persons Statistics Bar;
The method also includes:
According to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second serial number;
Second serial number is successively added to position corresponding with the hiring date of the office worker in the total number of persons Statistics Bar It sets.
To achieve the goals above, this application provides a kind of table generating means, described device includes:
Statistic unit, for counting position level, hiring date, year of birth, the name, hilllock of each office worker in specific office Position title and head portrait picture;
Establish unit, for preset position level be column, with the hiring date of each office worker be row establish table;
Adding unit, for the position level and hiring date according to each office worker, by the year of birth of each office worker, name, Post title and head portrait picture are added on the corresponding position in the table.
Optionally, the hiring date includes: registration time and registration date;
It is described establish unit for preset position level be column, with the hiring date of each office worker be row establish table When, it is specifically used for:
It is column using preset position level, using the registration time of each office worker is as the first row, with the registration date of each office worker Second row establishes the table;
Wherein, in a column direction, the registration date of each office worker is correspondingly arranged with the registration time of the office worker;
The column on the registration date with the identical registration time constitutes a column.
Optionally, the registration date in a column successively arranges according to the sequencing of time.
Optionally, the table further include:
Registration time demographics row;
The adding unit, is also used to:
According to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes the first sequence Number;
First serial number is added to corresponding with the registration date in the column in the registration time demographics row On position.
Optionally, the table further include:
Total number of persons Statistics Bar;
The adding unit, is also used to:
According to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second serial number;
Second serial number is successively added to position corresponding with the hiring date of the office worker in the total number of persons Statistics Bar It sets.
The technical solution that embodiments herein provides can include the following benefits:
In this application, statistics specific office in each office worker position level, hiring date, year of birth, name, hilllock Position title and head portrait picture after establish with preset position level be column, with the hiring date of each office worker be row establish table, so Afterwards according to the position level and hiring date of each office worker, the year of birth of each office worker, name, post title and head portrait picture are added It is added on the corresponding position in the table, since the year of birth of each office worker, name, post title and head portrait picture can add It is added in table on position corresponding with the office worker, and when the position is able to reflect out the corresponding position level of the office worker and registration Between, thus can be determined by the position position level of the office worker, hiring date, year of birth, name, post title and Head portrait picture, also, the office worker of same position level can show that the different hiring dates in same a line in this table are corresponding Position on, the office worker of identical hiring date can show the corresponding position of different position levels in same row in this table On, therefore intuitively each office worker in a department can be analyzed by the table and personnel information counts, Such as: can determine personnel and the registration number of a certain time registration faster;The a certain time, personnel were recruited in which post;It should Distributed how many office worker on different position levels in department;How many office worker on a certain position level;On same position level There is which office worker and these office workers are the information such as the post where which year birth and these office workers, consequently facilitating User quickly grasps the rough idea of the office worker of the department, and formulates corresponding plan for adjustment, for example, working as a certain position When being recruited, it can quickly determine which office worker can be competent at the position by the table, it can be true by the table Make the development plan of the talent.
Detailed description of the invention
The attached drawing constituted part of this application is used to provide further understanding of the present application, so that the application's is other Feature, objects and advantages become more apparent upon.The illustrative examples attached drawing and its explanation of the application is for explaining the application, not Constitute the improper restriction to the application.In the accompanying drawings:
Fig. 1 is a kind of schematic diagram of table in the prior art;
Fig. 2 is a kind of flow diagram of table generation method provided by the present application;
Fig. 3 is a kind of schematic diagram of table provided by the present application;
Fig. 4 is the schematic diagram of another table provided by the present application;
Fig. 5 is the flow diagram of another table generation method provided by the present application;
Fig. 6 is the schematic diagram of another table provided by the present application;
Fig. 7 is the flow diagram of another table generation method provided by the present application;
Fig. 8 is the schematic diagram of another table provided by the present application;
Fig. 9 is the schematic diagram of another table provided by the present application;
Figure 10 is a kind of structural schematic diagram of table generating means provided by the present application.
Specific embodiment
In order to make those skilled in the art more fully understand application scheme, below in conjunction in the embodiment of the present application Attached drawing, the technical scheme in the embodiment of the application is clearly and completely described, it is clear that described embodiment is only The embodiment of the application a part, instead of all the embodiments.Based on the embodiment in the application, ordinary skill people Member's every other embodiment obtained without making creative work, all should belong to the model of the application protection It encloses.
It should be noted that the description and claims of this application and term " first " in above-mentioned attached drawing, " Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.It should be understood that using in this way Data be interchangeable under appropriate circumstances, so as to embodiments herein described herein.In addition, term " includes " and " tool Have " and their any deformation, it is intended that cover it is non-exclusive include, for example, containing a series of steps or units Process, method, system, product or equipment those of are not necessarily limited to be clearly listed step or unit, but may include without clear Other step or units listing to Chu or intrinsic for these process, methods, product or equipment.
In this application, term " on ", "lower", "left", "right", "front", "rear", "top", "bottom", "inner", "outside", " in ", "vertical", "horizontal", " transverse direction ", the orientation or positional relationship of the instructions such as " longitudinal direction " be orientation based on the figure or Positional relationship.These terms are not intended to limit indicated dress primarily to better describe the application and embodiment Set, element or component must have particular orientation, or constructed and operated with particular orientation.
Also, above-mentioned part term is other than it can be used to indicate that orientation or positional relationship, it is also possible to for indicating it His meaning, such as term " on " also are likely used for indicating certain relations of dependence or connection relationship in some cases.For ability For the those of ordinary skill of domain, the concrete meaning of these terms in this application can be understood as the case may be.
In addition, term " installation ", " setting ", " being equipped with ", " connection ", " connected ", " socket " shall be understood in a broad sense.For example, It may be a fixed connection, be detachably connected or monolithic construction;It can be mechanical connection, or electrical connection;It can be direct phase It even, or indirectly connected through an intermediary, or is two connections internal between device, element or component. For those of ordinary skills, the concrete meaning of above-mentioned term in this application can be understood as the case may be.
It should be noted that in the absence of conflict, the features in the embodiments and the embodiments of the present application can phase Mutually combination.The application is described in detail below with reference to the accompanying drawings and in conjunction with the embodiments.
Fig. 2 is a kind of flow diagram of table generation method provided by the present application, and this method can be executed in personal electricity In the equipment such as brain, portable device, mobile phone, as shown in Fig. 2, method includes the following steps:
201, count the position level of each office worker in specific office, hiring date, year of birth, name, post title and Head portrait picture.
For example, can be counted by including the table of above- mentioned information, table when statistically stating information Pattern after using table style as shown in Figure 1, above- mentioned information can be advantageously reduced defeated with pattern as shown in Figure 1 Enter component difficulty when table, naturally it is also possible to be counted by other means, specific statistical is no longer detailed herein It repeats, but all implementations that can count on above- mentioned information belong to the protection scope of the application.
It should be noted that in addition to that information, other information can also be counted according to actual needs, for example, each duty The age of member and family status information etc., the information about statistics can be set according to actual needs, not done herein specific It limits.
By taking Finance Department as an example, post title includes: cashier, cost accounting, tax accounting, financial accounting, Finance Department's warp Reason and Chief Financial Officer can determine the corresponding specific post title of the office worker according to post where office worker.
202, with preset position level be column, with the hiring date of each office worker be row establish table.
Illustratively, Fig. 3 is a kind of schematic diagram of table provided by the present application, as shown in figure 3, preset position level can It is from A grades to F grades respectively to include 6.
It should be noted that the value volume and range of product about preset position level can be carried out according to the actual needs of department Setting, is not specifically limited herein.
It needs to be noted again that, in a department, office worker may be not present on a certain preset position level, or Person, there may be multiple office workers on a certain preset position level, as shown in figure 3, can will be on a certain default position level Office worker's number be labeled on the default position level.
203, according to the position level and hiring date of each office worker, by the year of birth of each office worker, name, post title and Head portrait picture is added on the corresponding position in the table.
For example, hiring date is 2018, which exists as shown in figure 3, the position level of a certain office worker is F grades It is position that column in 2018 intersects that be default position level, which be expert at by F grade with hiring date, for corresponding position on table Place, then by the personnel information of the office worker: year of birth, name, post title and head portrait picture are added in this position.
In this application, statistics specific office in each office worker position level, hiring date, year of birth, name, hilllock Position title and head portrait picture after establish with preset position level be column, with the hiring date of each office worker be row establish table, so Afterwards according to the position level and hiring date of each office worker, the year of birth of each office worker, name, post title and head portrait picture are added It is added on the corresponding position in the table, since the year of birth of each office worker, name, post title and head portrait picture can add It is added in table on position corresponding with the office worker, and when the position is able to reflect out the corresponding position level of the office worker and registration Between, thus can be determined by the position position level of the office worker, hiring date, year of birth, name, post title and Head portrait picture, also, the office worker of same position level can show that the different hiring dates in same a line in this table are corresponding Position on, the office worker of identical hiring date can show the corresponding position of different position levels in same row in this table On, therefore intuitively each office worker in a department can be analyzed by the table and personnel information counts, Such as: can determine personnel and the registration number of a certain time registration faster;The a certain time, personnel were recruited in which post;It should Distributed how many office worker on different position levels in department;How many office worker on a certain position level;On same position level There is which office worker and these office workers are the information such as the post where which year birth and these office workers, consequently facilitating User quickly grasps the rough idea of the office worker of the department, and formulates corresponding plan for adjustment, for example, working as a certain position When being recruited, it can quickly determine which office worker can be competent at the position by the table, it can be true by the table Make the development plan of the talent.
It should be noted that the specific pattern for the table that the application generates can refer to shown in Fig. 3, also, closed in the application It is not especially limited in the particular use of table.
In a feasible embodiment, the hiring date includes: registration time and registration date, is realizing step When 201, specifically can be using preset position level column, using the registration time of each office worker as the first row, with the registration of each office worker Date is that the second row establishes the table, wherein in a column direction, the registration date of each office worker and the registration time pair of the office worker It should be arranged;The column on the registration date with the identical registration time constitutes a column, and the table of formation can refer to shown in Fig. 4, Fig. 4 For the schematic diagram of another table provided by the present application.
Specifically, as shown in figure 4, the office worker of registration in 2017 includes 2 people, and the registration date is respectively 3.13 and 9.01, 2017.3.13 and 2017.9.01 column is formed into a column, i.e. the column are for indicating the office worker of registration in 2017, using upper After stating design, intuitively the personnel information of each time registration can be counted, and the table can be clearly shown respectively The office worker of time registration and in a certain time each office worker's registration the registration date.
In a feasible embodiment, the registration date in a column successively arranges according to the sequencing of time Cloth.
Specifically, as shown in figure 4, office worker 4 and office worker 5 are registration in 2017, and the registration date of office worker 4 is 3.13, registration date of office worker 5 is 9.01, when in 2017, the corresponding registration date was arranged, successive suitable according to the time Sequence, to 3.13 and 9.01, the two registration dates are successively sorted, and are specifically referred to shown in Fig. 4, after adopting the above method, It can intuitively reflect that the office worker's for when having office worker's registration and same year registration in a certain registration time is successive suitable The information such as sequence.
In a feasible embodiment, the table further include: registration time demographics row, registration time people Number Statistics Bar is used to reflect the number of a certain time registration, and Fig. 5 is the process of another table generation method provided by the present application Schematic diagram, as shown in figure 5, this method is further comprising the steps of:
501, according to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes first Serial number.
502, first serial number is added in the registration time demographics row and the registration date pair in the column On the position answered.
Specifically, Fig. 6 is the schematic diagram of another table provided by the present application, as shown in fig. 6, this column in 2017 are corresponding The registration date includes 3.13 and 9.01, is for the serial number B1 of 3.13 distribution according to the sequencing on the two registration dates The serial number B2 of 9.01 distribution, by B2 it is found that there is two people's registrations for 2017, to be conducive to quickly to the office worker in a certain time Information is counted.
It should be noted that the representation of the first serial number as shown in FIG. 6 can be set according to actual needs, This is not specifically limited.
It should be noted that as shown in fig. 6, the registration time of position to be recruited can be set when existing when recruiting position It as shown in fig. 6, setting 2018 for the registration time of position to be recruited, also, is to be somebody's turn to do duty to be recruited for a maximum registration time The serial number of bit allocation can be B2, if continuing to set the registration time for being somebody's turn to do position to be recruited to there are one position to be recruited 2018, and be the serial number of position to be recruited distribution can be B3.
In a feasible embodiment, the table further include: total number of persons Statistics Bar, the total number of persons Statistics Bar are used for Reflect that the total number of persons of the department, Fig. 7 are the flow diagram of another table generation method provided by the present application, as shown in fig. 7, This method is further comprising the steps of:
701, according to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second sequence Number.
702, second serial number is successively added to corresponding with the hiring date of the office worker in the total number of persons Statistics Bar Position on.
Specifically, Fig. 8 is the schematic diagram of another table provided by the present application, as shown in figure 8, the part includes 6 duties Member, and hiring date according to the serial number that the sequencing of hiring date is above-mentioned 6 office workers distribution respectively as shown in figure 8, divide It is not that: A1-A6 can determine that the total number of persons of the department is 6 people by A6.
For position to be recruited, as shown in figure 8, the registration time of position to be recruited can be set when existing when recruiting position It as shown in figure 8, setting 2018 for the registration time of position to be recruited, also, is to be somebody's turn to do duty to be recruited for a maximum registration time The serial number of bit allocation can be A7, if continuing to set the registration time for being somebody's turn to do position to be recruited to there are one position to be recruited 2018, and be the serial number of position to be recruited distribution can be A8.
It should be noted that the representation of the second serial number as shown in Figure 8 can be set according to actual needs, This is not specifically limited.
In a feasible embodiment, the table of generation specifically can be as shown in figure 9, Fig. 9 be provided by the present application The schematic diagram of another table, as shown in figure 9, the date indicates that registration date, time indicate the registration time, serial number divided to indicate registration Time demographics row, total serial number indicate total number of persons Statistics Bar.
Include following several by the information that other personal information of Fig. 9 combination office worker can be known:
1, Finance Center has 6 on-the-job personnel: chief inspector grade (F grades) 1 people, line manager grade (E grades) 1 people, Zhu Guanji at present (C grades) 1 people, senior staff grade (B grades) 3 people;Manager grade (D grades) personnel need to be supplemented;
2, within 2018 years, Finance Center is up to 8 on-the-job personnel, handles grade (D grades) 2 people for increasing, to strengthen " financial analysis, capital management " 2 aspect professional work, the financial preparation before tentatively meeting the quasi- listing of enterprise;
3, by 5 years (2013 --- 2018), Finance Center has accumulated 6 on-the-job personnel, wherein 2017 2 people of registration, other times each 1 people of registration;Remarks: financial executive Wang Yi purlin was called in finance by administrative driver post in 2015 and is gone out It receives post, was promoted as financial executive in 2017;
4, the average age of Finance Center staff is 35.7 years old.Wherein: Chief Financial Officer's Zhao Jingjing age is 37 years old, year Age is suitable for having esbablished corporation with hilllock working experience, and financial management major Master degree candidate graduation has new high-tech enterprise's finance Overall work experience has overall financial preparation experience before the listing of a company, in registration in April, 2018, needs to be tried at present With end-of-term examination core;Manager of financial department Chen Hong, financial executive Wang Yi purlin are all strangers (now 48 years old) in 1970, are come from age dimension It sees do not have promotion potentiality, from the point of view of the time that graduated school and educational background obtain, does not also have professional potentiality;Chen Hongjing The operational advantages of reason are to be familiar with Finance Department's various work status, diligent, careful in work, but in financial system There are obvious short slabs in terms of thinking;The operational advantages of Wang Yi purlin supervisor are professional dedication and the loyalty to enterprise, in work Willingly, but professional depth is limited, the slightly aobvious lag of job schedule;The tax accounting pungent grass age is 25 years old, and registration was close to 2 years Time, this is its postgraduate 1st part and works that eager to learn ready to work in work, practical experience is more sturdy, and working face still needs to be opened up It is wide;The cost accounting Li Yu paulownia age is 27 years old, and married unfertilized (having raw baby to plan 30 years old front and back), hiring date alreadys exceed 1 Year, achievement on duty is good, there is long-term work wish, semi-senior accountant's qualification is admitted in the recent period, once in well-known meeting before registration Lawyer's offices' work is counted, working efficiency is higher, and career development potentiality are preferable, and successor value must be used as Finance Analysts Manager people from post Choosing receives further to investigate, and clearly promotes matters;Receiving and paying out the Jiang Yao age is 30 years old, and Beijing nationality, married to have educated, family financial situation is preferable, Child 6 years old (or having two children plan), the daily commuter time is more punctual, can accurately execute routine work task, but wealth Business experience is more single, has no obvious interest, non-financial major, subsequent transfer-position Shanxi to the action except its this post It is smaller to rise potentiality;
5, the current personnel and post matching situation of Finance Center is: Chief Financial Officer's Zhao Jingjing hiring date is shorter, needs the trial period Examination, the subsequent prospect that it pulls financial overall work looks to be promoted are still uncertain;Manager of financial department's Chen Hong hiring date is opposite It is relatively early, it is familiar with Finance Department's work present situation, can satisfy daily Finance Department's work linking needs, but professional idea is more traditional, The work style of itself and new registration Chief Financial Officer agree with situation still and have to be seen;Financial executive's Wang Yi purlin hiring date is more early, in To Finance Department, professional dedication is praiseworthy, and professional ability is insufficient, can cultivate limited potential for way transfer-position;Cost accounting Li Yu paulownia meaning on duty It is willing to stablize, promotes wish and define, financial analysis warp is promoted as in professional knowledge and practical experience relative abundance, subsequent suitable consideration Reason, to play bigger work values, what the same period needed to consider cost accounting post takes over person;The pungent grass of tax accounting situation on duty Well, while also there will be transfer-position tentatively in face of professional bottleneck period and expand the needs that face is competent in work, subsequent suitable consideration is taken over The cost accounting post of Li Yu paulownia works, and continues to cultivate experience and tempering;Cashier Jiang Yao can be competent at the work of current post, temporarily without transfer-position, Promotion demand;Employee's grade (A grades) post can supplement new person 1 (containing: graduating student person) in the recent period, and person needs to have good Good growing potential, by strengthening practice training, is striven for reaching and takes over tax accounting post in 3 months that person enters trade-after Work strength;The same period recruits capital management manager (D grades) person 1, needs to have 2 years or more with hilllock working experience, needs There is sturdy profession experience in adult form finance team;
6, by analyzing above, the Talent Development demand of Finance Center is mainly reflected in: concern Chief Financial Officer Zhao Jingjing's Trial period Check and financial system constructive ability;Pay close attention to manager of financial department Chen Hong's and new registration Chief Financial Officer Zhao Jingjing Work collaboration situation;Post can be provided to cost accounting Li Yu paulownia promote space;The same period can provide to the pungent grass of tax accounting Exercise machine of transferring meeting;Financial executive Wang Yi purlin, cashier Jiang Yao can temporarily be competent at current post work, balanced condition on duty;It recruits Plan is engaged to be adjusted to the employee grade person of financial manager's grade person 1 of recruitment 1 by 2 financial manager grade persons of recruitment, to drop Low recruitment difficulty, intensity and wage appropriation budget.
It should be noted that 6 ranks (A grades-F grades) shown in Fig. 9 are merely exemplary, 8 grades can also be arranged to It not, is from A grades-H grades respectively, specific number of levels and grade setting principle are set according to actual needs, are not done herein It is specific to limit, by for A grade-H grades, the corresponding relationship of rank and post are as follows: employee's (A grades), is responsible for senior staff's (B grades) (C grades), manager (D grades), chief of ship branch (E grades), chief inspector's (F grades), vice president's (G grades), president's (H grades).
(A grades) of employee positioning: having specific work wish, there is good career growth potentiality, but in current routine It still can malfunction frequently in work, performance index can not undertaken temporarily.
(B grades) of senior staff positioning: based on A grades, specific performance index has been undertaken;It can accomplish in routine work Few error, but its adequate working face is still limited.
(C grades) positioning of supervisor:: based on B grades, adequate working face is 3 times of B grades or so, has been undertaken obvious Specific performance index, 3-5 people work group (subordinate be B grades, A grades of employees) can be led;Have primary management awareness, mood Automatic control level is good.
(D grades) positioning of manager: based on B grades, adequate working face is 5 times of B grades or so, has undertaken key and has accounted for The performance index of ratio, professional operation level are prominent;It is good at finding the problem, be better than innovation and solves the problems, such as;It is the inclined of professional domain Good person has the time of strong job interest and higher-strength to put into, and professional self-drive power is more powerful.
(E grades) of chief of ship branch positioning: based on C grades, adequate working face is 3 times of C grades or so, and it is whole to undertake department Body achievement responsibility;Have good overall qualities in terms of budget management, time management, team's culture, performance objectives; Have intermediate supervision awareness, have the courage and handle the minor issue of obscurity boundary, constructive can arrange daily department, is accustomed to In propagating positive energy, work implementation capacity is outstanding.
(F grades) of chief inspector positioning: based on D grades+E grades, adequate working face is 3 times of E grades or so, undertakes work The optimization responsibility of system overall efficiency;It drafts in direction control, risk prevention system, goal task, have obviously in terms of tactful supports Professional advantage;Has intermediate supervision awareness, the various particular problems of processing obscurity boundary that can be relatively appropriate;Have good Career development potentiality.
(G grades) of vice president positioning: based on E grades, adequate working face is 5 times of E grades or so;According to the war of enterprise Slightly development need can carry out several work systems to continue integration;Have higher management awareness, can appropriately handle various spine Hand problem, moral standing are sturdy;Compared with professional ability, more outstanding with vice president grade person is strengthening one's conviction and chase after to enterprise With.
(H grades) of president positioning:: undertake comprehensive responsibility (containing: the responsibility of legal perspective);It is responsible for holding corporate strategy development Direction puts forth effort to obtain enterprise external resource, identifies the market opportunity and window phase, coordinate and balance the distribution of internal enterprise resources With application (contain: business zoning, personal scheduling, authorization system, interests expection, capital investment, process, mechanism, time quantum, etc.), Return the business expectations of shareholder and investor.
Figure 10 is a kind of structural schematic diagram of table generating means provided by the present application, as shown in Figure 10, described device packet It includes:
Statistic unit 1001, for counting position level, hiring date, year of birth, the surname of each office worker in specific office Name, post title and head portrait picture;
Establish unit 1002, for preset position level be column, with the hiring date of each office worker be row establish table;
Adding unit 1003, for the position level and hiring date according to each office worker, by the year of birth of each office worker, surname Name, post title and head portrait picture are added on the corresponding position in the table.
In a feasible embodiment, the hiring date includes: registration time and registration date;
In the unit 1002 of establishing for being column with preset position level, with the hiring date of each office worker being capable foundation When table, it is specifically used for:
It is column using preset position level, using the registration time of each office worker is as the first row, with the registration date of each office worker Second row establishes the table;
Wherein, in a column direction, the registration date of each office worker is correspondingly arranged with the registration time of the office worker;
The column on the registration date with the identical registration time constitutes a column.
In a feasible embodiment, the registration date in a column successively arranges according to the sequencing of time Cloth.
In a feasible embodiment, the table further include:
Registration time demographics row;
The adding unit 1003, is also used to:
According to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes the first sequence Number;
First serial number is added to corresponding with the registration date in the column in the registration time demographics row On position.
In a feasible embodiment, the table further include:
Total number of persons Statistics Bar;
The adding unit 1003, is also used to:
According to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second serial number;
Second serial number is successively added to position corresponding with the hiring date of the office worker in the total number of persons Statistics Bar It sets.
About in above-described embodiment device execute operation concrete mode in the embodiment of the method into Detailed description is gone, no detailed explanation will be given here.
In this application, statistics specific office in each office worker position level, hiring date, year of birth, name, hilllock Position title and head portrait picture after establish with preset position level be column, with the hiring date of each office worker be row establish table, so Afterwards according to the position level and hiring date of each office worker, the year of birth of each office worker, name, post title and head portrait picture are added It is added on the corresponding position in the table, since the year of birth of each office worker, name, post title and head portrait picture can add It is added in table on position corresponding with the office worker, and when the position is able to reflect out the corresponding position level of the office worker and registration Between, thus can be determined by the position position level of the office worker, hiring date, year of birth, name, post title and Head portrait picture, also, the office worker of same position level can show that the different hiring dates in same a line in this table are corresponding Position on, the office worker of identical hiring date can show the corresponding position of different position levels in same row in this table On, therefore intuitively each office worker in a department can be analyzed by the table and personnel information counts, Such as: can determine personnel and the registration number of a certain time registration faster;The a certain time, personnel were recruited in which post;It should Distributed how many office worker on different position levels in department;How many office worker on a certain position level;On same position level There is which office worker and these office workers are the information such as the post where which year birth and these office workers, consequently facilitating User quickly grasps the rough idea of the office worker of the department, and formulates corresponding plan for adjustment, for example, working as a certain position When being recruited, it can quickly determine which office worker can be competent at the position by the table, it can be true by the table Make the development plan of the talent.
The foregoing is merely preferred embodiment of the present application, are not intended to limit this application, for the skill of this field For art personnel, various changes and changes are possible in this application.Within the spirit and principles of this application, made any to repair Change, equivalent replacement, improvement etc., should be included within the scope of protection of this application.

Claims (10)

1. a kind of table generation method, which is characterized in that the described method includes:
Count position level, hiring date, year of birth, name, post title and the head portrait picture of each office worker in specific office;
With preset position level be column, with the hiring date of each office worker be row establish table;
According to the position level and hiring date of each office worker, by the year of birth of each office worker, name, post title and head portrait picture It is added on the corresponding position in the table.
2. the method as described in claim 1, which is characterized in that the hiring date includes: registration time and registration date;
It is described with preset position level be column, with the hiring date of each office worker be row establish table, comprising:
Using preset position level be column, using the registration time of each office worker as the first row, with the registration date of each office worker be second Row establishes the table;
Wherein, in a column direction, the registration date of each office worker is correspondingly arranged with the registration time of the office worker;
The column on the registration date with the identical registration time constitutes a column.
3. method according to claim 2, which is characterized in that positioned at one column in the registration date according to the time sequencing Successively arrange.
4. method as claimed in claim 3, which is characterized in that the table further include:
Registration time demographics row;
The method also includes:
According to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes the first serial number;
First serial number is added to position corresponding with the registration date in the column in the registration time demographics row On.
5. method as claimed in claim 3, which is characterized in that the table further include:
Total number of persons Statistics Bar;
The method also includes:
According to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second serial number;
Second serial number is successively added in the total number of persons Statistics Bar on position corresponding with the hiring date of the office worker.
6. a kind of table generating means, which is characterized in that described device includes:
Statistic unit, for counting the position level, hiring date, year of birth, name of each office worker in specific office, post name Title and head portrait picture;
Establish unit, for preset position level be column, with the hiring date of each office worker be row establish table;
Adding unit, for the position level and hiring date according to each office worker, by the year of birth, name, post of each office worker Title and head portrait picture are added on the corresponding position in the table.
7. device as claimed in claim 6, which is characterized in that the hiring date includes: registration time and registration date;
It is described establish unit for preset position level be column, with the hiring date of each office worker be row establish table when, It is specifically used for:
Using preset position level be column, using the registration time of each office worker as the first row, with the registration date of each office worker be second Row establishes the table;
Wherein, in a column direction, the registration date of each office worker is correspondingly arranged with the registration time of the office worker;
The column on the registration date with the identical registration time constitutes a column.
8. device as claimed in claim 7, which is characterized in that positioned at one column in the registration date according to the time sequencing Successively arrange.
9. device as claimed in claim 8, which is characterized in that the table further include:
Registration time demographics row;
The adding unit, is also used to:
According to the distributing order on the registration date being located in a column, the registration date being followed successively by the column distributes the first serial number;
First serial number is added to position corresponding with the registration date in the column in the registration time demographics row On.
10. device as claimed in claim 8, which is characterized in that the table further include:
Total number of persons Statistics Bar;
The adding unit, is also used to:
According to the distributing order of the hiring date of each office worker, the hiring date for being followed successively by each office worker distributes the second serial number;
Second serial number is successively added in the total number of persons Statistics Bar on position corresponding with the hiring date of the office worker.
CN201810681692.9A 2018-06-27 2018-06-27 A kind of generation method and device of table Pending CN109062878A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810681692.9A CN109062878A (en) 2018-06-27 2018-06-27 A kind of generation method and device of table

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810681692.9A CN109062878A (en) 2018-06-27 2018-06-27 A kind of generation method and device of table

Publications (1)

Publication Number Publication Date
CN109062878A true CN109062878A (en) 2018-12-21

Family

ID=64818030

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810681692.9A Pending CN109062878A (en) 2018-06-27 2018-06-27 A kind of generation method and device of table

Country Status (1)

Country Link
CN (1) CN109062878A (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110378509A (en) * 2019-05-30 2019-10-25 平安科技(深圳)有限公司 Data predication method, device, computer equipment and storage medium

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1367514A1 (en) * 2002-05-29 2003-12-03 Framtidsforum I & M AB Method in connection with a spreadsheet program
CN101847152A (en) * 2010-02-01 2010-09-29 浪潮集团山东通用软件有限公司 Statistical analysis method and statistical analysis system for statements of various criterions based on data unit
CN101876970A (en) * 2009-12-22 2010-11-03 金蝶软件(中国)有限公司 Method for combining reports and device thereof

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
EP1367514A1 (en) * 2002-05-29 2003-12-03 Framtidsforum I & M AB Method in connection with a spreadsheet program
CN101876970A (en) * 2009-12-22 2010-11-03 金蝶软件(中国)有限公司 Method for combining reports and device thereof
CN101847152A (en) * 2010-02-01 2010-09-29 浪潮集团山东通用软件有限公司 Statistical analysis method and statistical analysis system for statements of various criterions based on data unit

Non-Patent Citations (6)

* Cited by examiner, † Cited by third party
Title
刘胜达 等: "Excel VBA在玉米数量性状统计中的应用", 《智能计算机与应用》 *
古典 等: "《大学生职业发展与就业指导 铜陵职业技术学院》", 31 July 2017, 成都:电子科技大学出版社 *
朱洁兰: "ExcelVBA实现企业人事数据分析自动化", 《数字技术与应用》 *
杨俊宴: "《城市设计语汇》", 31 December 2017, 沈阳:辽宁科学技术出版社 *
沈双一 等: "《工作分析》", 30 November 2004 *
连玉明 等: "《大数据1705》", 31 January 2017, 北京:团结出版社 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110378509A (en) * 2019-05-30 2019-10-25 平安科技(深圳)有限公司 Data predication method, device, computer equipment and storage medium
CN110378509B (en) * 2019-05-30 2022-12-02 平安科技(深圳)有限公司 Data prediction method, data prediction device, computer equipment and storage medium

Similar Documents

Publication Publication Date Title
Card et al. Small differences that matter: Labor markets and income maintenance in Canada and the United States
Boser Teacher Diversity Matters: A State-by-State Analysis of Teachers of Color.
Sterling et al. Navigating the gap: Reflections on 20 years researching gender disparities in the legal profession
Salamon The presidency and domestic policy formulation
Claussen Trade administration
Bramble Deterring democracy? Australia's new generation of trade union officials
Cao Contradiction between input and output of Chinese scientific research: a multidimensional analysis
Khumawala et al. Accounting professionalism and local government GAAP adoption: A national study
Baxter et al. Labor and politics in the US Postal Service
CN109062878A (en) A kind of generation method and device of table
CN109064107A (en) A kind of human resources inquiry management system
Masters Federal-sector unions: Current status and future directions
Charo Designing Mathematical Models to Describe One-Person, One-Vote Compliance by Unique Governmental Structures: The Case of the New York City Board of Estimate
Gregory Lessons from Publius for Contemporary Labor Law
Bonvecchi et al. The Presidency and the Executive Branch in Latin America
Cai A study on the effectiveness of career information collection as a way to promote graduate students’ employment
Hadzi-Vaskov Assessing the Macroeconomic Impact of Structural Reforms in Chile
Pengxi The construction study of college informationization teaching service system under the background of big data
Clagett Strategic planning at carroll community college
MacMillan Recognition theory and institutional labour economics
DİLAVER Accounting And Auditing In The Digital Economy
Jun'e University Financial Management and Decision Analysis based on Decision Tree Algorithm
Heritage Departmental Sustainable Development Strategy-Departmental Results Report 2017-2018
Campbell et al. Moving target: the regulation of judges in China’s rapidly evolving legal system
Orzeł International Road Transport in the Outsourcing Aspect on the Example of Poland

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination