In the "ledger" as shown in the figure, enter the title of the first line, and the following data, according to the needs of the unit to modify the content of the data.
In the "Browse" worksheet, set up the table according to the figure. Bold characters and the "ledger" in the title line corresponds to, pay attention to the location of the items
2, add controls
Call up the "Forms" toolbar (press "View - Toolbars - Forms") -Toolbar - Forms"), select the "fine-tuning item" control, draw a fine-tuning button anywhere on the screen.
Right-click the fine-tuning button, in the shortcut menu that appears, select "Set Control Format", and then set the following figure, OK.
3, add the formula in the "Browse" worksheet according to the figure below to add the formula. Here to use an EXCEL function, which is defined as: the specified reference to the reference system, through the given offset to get a new reference. can be in excel comes with the help file to find the OFFSET function of the detailed usage. The cell formula is as follows: B2 = OFFSET (Ledger! $B $ 1, browse! $F$1,0)B3 =OFFSET(Ledger! $B$1,Browse! $F$1,3)B4 =OFFSET(Ledger! $B$1, Browse! $F$1,6)B5 =OFFSET(Ledger! $B$1, Browse! $F$1,9)B6 =OFFSET(Ledger! $B$1, Browse! $F$1,12)D2 =OFFSET(Ledger! $B$1,Browse! $F$1,1)D3 =OFFSET(Ledger! $B$1,Browse! $F$1,4)D4 =OFFSET(Ledger! $B$1,Browse! $F$1,7)D5 =OFFSET(Ledger! $B$1,Browse! $F$1,10)D6 =OFFSET(Ledger! $B$1,Browse! $F$1,13)F2 =OFFSET(Ledger! $B$1,Browse! $F$1,2)F3 =OFFSET(Ledger! $B$1, Browse! $F$1,5)F4 =OFFSET(Ledger! $B$1, Browse! $F$1,8)F5 =OFFSET(Ledger! $B$1,Browse! $F$1,11)
4, the use of "Browse" worksheet by pressing the fine-tuning buttons, you can turn the page up or down, showing different fixed asset cards. This fixed asset ledger can also be changed slightly, as other templates to use, such as: address book, e-books, employee records and so on.
Question 2: How to make a data ledger? Fourth, machinery and equipment management system
Description:
1, production safety management system refers to the enterprise or project must be developed and implemented according to the "standard" requirements of the system. Including construction organization design and special safety construction program system: safety and technical measures to implement the plan system; safety and technical delivery *** system; frame, equipment installation acceptance system; construction equipment acceptance and maintenance and repair system; safety inspection system; safety education and training system; casualties and accidents report system; assessment and reward system; team safety activities system; guard duty and security system; fire prevention and fire protection Responsibility system; health cleaning system; non-disturbance measures, etc.; mobile population family planning management system; other management systems.
2, where the construction site involved in the types of work should be formulated safety technology operating procedures.
2. Safety production responsibility and target management
1. Safety production responsibility system for the main personnel and main functions of the enterprise
2. Safety production responsibility system for the management personnel of the project department
3. Safety production target responsibility book or economic contracting agreement
4, Project department safety production organization network
six, the project department safety production responsibility assessment provisions and records
seven, the project department safety target responsibility assessment provisions and records
3, the construction organization design
one, the construction organization design (including the project overview table)
two, the general layout of the construction site and the layout of the plane of the arrangement of safety signs
three, the construction organization design
two, the construction site general layout and the layout of the plane of the arrangement of safety signs <
Third, special safety construction program
4, division (sub) project safety technology briefing
Each division (sub) project, each type of work and other safety technology briefing record sheet
5, safety inspection
Safety Production Inspection Record Sheet
Description:
1, the project department should be in accordance with the standard "JGJ5999" and the "JGJ5999". JGJ59-99" and the provincial "Implementation Opinions" for inspection.
2, the safety inspection records should truly reflect the inspection of the safety problems and hidden accidents found, and according to the "three" requirements for the implementation of rectification, rectification matters should be reviewed.
3, the project foundation, the main body, roofing, decoration of the four stages shall be carried out safety inspection scores, and attached to the score sheet.
4, the regular and irregular safety inspection organized by the project department shall be reflected in the inspection record sheet.
5, the industry safety management department and enterprise inspection of the relevant information (accident hidden danger notice, rectification receipt, etc.) should be attached to this account.
6, safety education
First, the staff roster
Second, the staff of three safety education registration card (can be additionally centrally bound into a file)
Third, the change of the type of education registration form
Fourth, the staff of the safety knowledge test (the enterprise unified proposition to organize the examination, can be additionally bound into a file)
Fifth, the project department management personnel Annual training record table and copies of relevant post certificates
Six, roster of special operators and machine operators
Seven, special operators and machine operators on board a copy of the certificate
........................
12, sub-project safety technical requirements and acceptance
I. Scaffolding
Second, pit support
Third, template works
Fourth, "three treasures", "four mouths"
V. Construction electricity
VI. Material hoist (gantry, derrick)
VII. External elevator (man-cargo ladder)
VIII. Tower crane
IX. Lifting and hoisting
X. Construction machinery
Description: 1. "Acceptance results "column as quantitative as possible.
2, acceptance of more specialized sub-projects, the first to verify the special safety construction program, if there is no program or poorly targeted, no acceptance.
Question 3: What is the ledger? How to do? The contents of the ledger are many such as ---- production, cost, attendance ...... Geng ... The main time of occurrence, content, quantity, or else say specifically what the ledger
Question 4: How to do the ledger? The ledger is to process and organize and summarize the daily information. Convenient inquiry only, do not think too complicated! For example, manufacturers information, classification, summary. The formation of the ledger! Or you can also combine these customer information and manufacturer information!
Question 5: enterprise management ledger how to do enterprise management ledger, such as fixed asset management ledger, enterprise safety production ledger, personnel management ledger, merchandise purchase and sales ledger, etc., these ledgers are not only some statistics, including a number of documents, work plans, work reports, work summaries, as well as related information, divided into categories, organized into booklets cost, to facilitate the usual day-to-day access to the inspection and the higher level.
For enterprises, the more important ledgers are: financial management ledger, customer management ledger, production management ledger, personnel management ledger, administrative management ledger
Issue 6: how to do the ledger 1, first in the workbook to establish the two worksheets, respectively, named "ledger, "Browse".
In the "ledger" as shown in the figure, enter the title of the first line, and the following data, according to the needs of the unit to modify the data content.
In the "Browse" worksheet, set up the table according to the figure. Bold characters and the "ledger" in the title line corresponds to, pay attention to the location of the items
2, add controls
Call up the "Forms" toolbar (press "View - Toolbars - Forms") -Toolbar - Forms"), select the "fine-tuning item" control, draw a fine-tuning button anywhere on the screen.
Right-click the fine-tuning button, in the shortcut menu that appears, select "Set Control Format", and then set the following figure, OK.
3, add the formula in the "Browse" worksheet according to the figure below to add the formula. Here to use an EXCEL function, which is defined as: the specified reference to the reference system, through the given offset to get a new reference. can be in excel comes with the help file to find the OFFSET function of the detailed usage. The cell formula is as follows: B2 = OFFSET (Ledger! $B $ 1, browse! $F$1,0)B3 =OFFSET(Ledger! $B$1,Browse! $F$1,3)B4 =OFFSET(Ledger! $B$1, Browse! $F$1,6)B5 =OFFSET(Ledger! $B$1, Browse! $F$1,9)B6 =OFFSET(Ledger! $B$1, Browse! $F$1,12)D2 =OFFSET(Ledger! $B$1,Browse! $F$1,1)D3 =OFFSET(Ledger! $B$1,Browse! $F$1,4)D4 =OFFSET(Ledger! $B$1,Browse! $F$1,7)D5 =OFFSET(Ledger! $B$1,Browse! $F$1,10)D6 =OFFSET(Ledger! $B$1,Browse! $F$1,13)F2 =OFFSET(Ledger! $B$1,Browse! $F$1,2)F3 =OFFSET(Ledger! $B$1, Browse! $F$1,5)F4 =OFFSET(Ledger! $B$1, Browse! $F$1,8)F5 =OFFSET(Ledger! $B$1, Browse! $F$1,11)
4, the use of "Browse" worksheet by pressing the fine-tuning buttons, you can page up or down, showing different fixed asset cards. This fixed asset ledger can also be changed slightly, as other templates to use, such as: address book, e-books, employee records and so on.
Question 7: How to do the ledger The ledger is a detailed record of the table ~
That is, you do a list of all the expenses of a project ~
Do the ledger as long as the list is clear, in the said a little bit more understandable, the ledger is a running account.
Oh
Easy to cope with EXCEL form ~
Question 8: How to do the ledger ledger mainly depends on what category. If you do not know how to do the ledger, I can tell you the most basic universal method: one to understand the purpose of the ledger, in general, the ledger is to use the form of the table to clearly illustrate the problem, eliminating the need for many text description of the trouble. For the things to do the ledger, to be completely familiar with, comprehensive. Next, it is important to understand to whom the ledger is to be made and what things the person reading it is to understand. If these are taken into consideration, a very good ledger can be made. Then, there is the basic common sense of making a table. If you do not know where you can contact me
Question 9: How to do a good job of equipment accounts in order to facilitate the management of equipment, so the establishment of accounts
The content of the following: the name of the equipment, model specifications, the date of purchase, the use of years of service, depreciable life, asset number, the use of departmental use of the situation, and so on, in the form of tables to do so, every year need to be updated and inventories.
Do maintenance account is to facilitate future inquiries about the same failure to deal with the way, the most important thing is that if your company to carry out an annual audit, the auditor to look at, to see your maintenance status, treatment and so on. ---- basic content is; equipment name, number, use of the Department of the cause of the failure, the method of treatment, the replacement of the name of the spare parts, and so on