Enter the title of the first line and the following data in the "Account" as shown in the figure. The data content can be modified according to the needs of the company.
Set the table according to the chart in the browsing worksheet. Bold text corresponds to the title line in "Account". Pay attention to the position of each item.
2. Add controls
Call the Form toolbar (press View-Toolbar-Form), select the Rotate Item control, and draw a spin button anywhere on the screen.
Click this fine-tuning button with the right mouse button, select "Format Control" in the shortcut menu that appears, and then press the settings shown in the figure below to confirm.
3. Add a formula Add a formula to the browse worksheet, as shown below. An EXCEL function is used here, which is defined as: taking the specified reference as the frame of reference, and getting a new reference through the given offset. You can find the detailed usage of this OFFSET function in the help file attached to excel. The formula for each cell is as follows: B2 = Offset (Account! $B$ 1, browse! $F$ 1, 0)B3 = Offset (Account! $B$ 1, browse! $F$ 1, 3)B4 = offset (account! $B$ 1, browse! $F$ 1, 6)B5 = offset (account! $B$ 1, browse! $F$ 1, 9)B6 = offset (account! $B$ 1, browse! $F$ 1, 12)D2 = offset (account! $B$ 1, browse! $F$ 1， 1)D3 =OFFSET (account！ $B$ 1, browse! $F$ 1, 4)D4 = offset (account! $B$ 1, browse! $ F $ 1.7)D5 = offset (account! $B$ 1, browse! $F$ 1, 10)D6 = offset (account! $B$ 1, browse! $F$ 1， 13)F2 =OFFSET (account！ $B$ 1, browse! $F$ 1, 2)F3 =OFFSET (account! $B$ 1, browse! $ F $ 1.5)F4 = offset (account! $B$ 1, browse! $F$ 1，8)F5 =OFFSET (account！ $B$ 1, browse! $F$ 1， 1 1)
4. By clicking the fine-tuning button in the browse worksheet, you can page up and down and display different fixed assets cards. This fixed asset account can be slightly modified and used as other templates, such as address book, e-book, employee file, etc.
Question 2: How to make a data ledger? Four, mechanical equipment management system
Description:
1. Safety production management system refers to various systems that an enterprise or project department must formulate and implement according to the requirements of the Standard. Comprises a construction organization design and a special safety construction scheme compiling system; Safety technical measures plan implementation system; * * * degree of safety technology; Installation and acceptance system of frames and equipment; Acceptance and maintenance system of construction machines and tools; Safety inspection system; Safety education and training system; Casualty express system; Assessment reward and punishment system; Security team activity system; Security service and public security system; Fire prevention responsibility system; Sanitary cleaning system; Non-interference measures and so on. ; Family planning management system for floating population; Other management systems.
2, all types of work involved in the construction site should formulate safety technical operation procedures.
2, production safety responsibility and target management
First, the main personnel of the enterprise and the main functional departments of production safety responsibility system
Second, the project department management personnel safety production responsibility system
Three, safety production target responsibility or economic contract agreement
Four, the project department safety management target responsibility book
Five, the project department of production safety organization network
Six, the project department safety production responsibility system assessment rules and records
Seven, the project department safety target responsibility assessment rules and records
3, the construction organization design
A, the construction organization design (including project summary table)
Second, the construction site general layout and safety sign layout
Third, the special safety construction scheme
4, division (disciplines) engineering safety technical disclosure
Safety technical disclosure records of each division (sub-project) project and each type of work.
5, safety inspection
Safety production inspection record form
Description:
1, the project department should check according to the standard "JGJ59-99" and the provincial "Implementation Opinions".
2. The safety inspection records shall truly reflect the safety problems and hidden dangers of accidents found after various inspections, and make rectification according to the requirements of "three determinations", and the rectification items shall be reviewed.
3, engineering foundation, main body, capping, decoration four stages must be safety inspection score, and attach a score sheet.
4. The regular and irregular safety inspections organized by the Project Department should be reflected in the inspection records.
5. Relevant information (accident hidden danger notice, rectification receipt, etc.). ) The enterprise inspected by the industry safety management department shall attach this account.
6. Safety education
First, the staff roster
Second, the staff level 3 safety education registration card (can also be centralized binding into files)
Three, change the type of work education registration form
Four, employee safety knowledge examination (enterprise unified proposition organization examination, can also be bound)
Five, the project department management personnel annual training records and related post certificate copy.
Six, special operations personnel and mechanical operators roster
Seven, special operations personnel and mechanical operators certificate copy.
........................
12, safety technical requirements and acceptance of sectional works
A, scaffolding
Second, the foundation pit support
Third, the template project
Four, "three treasures" and "four mouths"
Five, construction electricity
Six, material hoist (gantry, tic-tac-toe frame)
7. External elevator (dual-purpose ladder for people and goods)
Eight, tower crane
Nine, weightlifting
X. Construction machinery and tools
Note: 1, the "acceptance result" column should be quantified as much as possible.
2, acceptance of professional subdivisional work, first verify the special safety construction scheme, if there is no scheme or pertinence is not strong, not acceptance.
Question 3: What is an account book? How? There are many contents in the account, such as output, cost, attendance ... Jin En ... mainly the time, content and quantity, or what is the specific account?
Question 4: How to make an account book? Accounting is to process and summarize daily data. Easy to query, don't think too complicated! For example, the information of manufacturers is classified and summarized. Form an account! Or you can combine these customer data with manufacturer data!
Question 5: How to make enterprise management ledger, such as fixed assets management ledger, enterprise safety production ledger, personnel management ledger, commodity purchase and sale ledger, etc. These ledgers are not only some statistical data, but also some documents, work plans, work reports, work summaries and related materials, which are classified into volumes for daily reference and superior inspection.
For enterprises, the more important general ledgers are: financial management general ledger, customer management general ledger, production management general ledger, personnel management general ledger, administrative management general ledger and so on.
Question 6: How to make an account book 1? First, create two worksheets in the workbook, named "Ledger" and "Browse" respectively.
Enter the title of the first line and the following data in the "Account" as shown in the figure. The data content can be modified according to the needs of the company.
Set the table according to the chart in the browsing worksheet. Bold text corresponds to the title line in "Account". Pay attention to the position of each item.
2. Add controls
Call the Form toolbar (press View-Toolbar-Form), select the Rotate Item control, and draw a spin button anywhere on the screen.
Click this fine-tuning button with the right mouse button, select "Format Control" in the shortcut menu that appears, and then press the settings shown in the figure below to confirm.
3. Add a formula Add a formula to the browse worksheet, as shown below. An EXCEL function is used here, which is defined as: taking the specified reference as the frame of reference, and getting a new reference through the given offset. You can find the detailed usage of this OFFSET function in the help file attached to excel. The formula for each cell is as follows: B2 = Offset (Account! $B$ 1, browse! $F$ 1, 0)B3 = Offset (Account! $B$ 1, browse! $F$ 1, 3)B4 = offset (account! $B$ 1, browse! $F$ 1, 6)B5 = offset (account! $B$ 1, browse! $F$ 1, 9)B6 = offset (account! $B$ 1, browse! $F$ 1, 12)D2 = offset (account! $B$ 1, browse! $F$ 1， 1)D3 =OFFSET (account！ $B$ 1, browse! $F$ 1, 4)D4 = offset (account! $B$ 1, browse! $ F $ 1.7)D5 = offset (account! $B$ 1, browse! $F$ 1, 10)D6 = offset (account! $B$ 1, browse! $F$ 1， 13)F2 =OFFSET (account！ $B$ 1, browse! $F$ 1, 2)F3 =OFFSET (account! $B$ 1, browse! $ F $ 1.5)F4 = offset (account! $B$ 1, browse! $F$ 1，8)F5 =OFFSET (account！ $B$ 1, browse! $F$ 1， 1 1)
4. By clicking the fine-tuning button in the browse worksheet, you can page up and down and display different fixed assets cards. This fixed asset account can be slightly modified and used as other templates, such as address book, e-book, employee file, etc.
Question 7: How to make accounts? An account number is a detailed record table ~
It's a list of all the expenses you spend on a project ~
As long as the list is sorted out clearly and clearly, the general ledger is a running account.
Hmm. How interesting
Easy to deal with with with EXCEL tables ~
Question 8: How to make an account mainly depends on what kind of account it is. If you don't know how to make account books, I can tell you the most basic and omnipotent methods: First, understand the purpose of account books. Generally speaking, the ledger is to clarify the problem in the form of a table, which saves a lot of trouble in words. Fully familiar with and fully understand the matters that need to be explained. Secondly, we should know who this account should be paid to and who should know it. If you take all these into account, you can make a good account. Moreover, it is the basic common sense of making watches. You can contact me if you have any questions.
Question 9: How to do a good job of equipment account In order to facilitate equipment management, establish an account.
Its contents include: equipment name, model and specification, purchase date, service life, depreciation life, asset number, usage of user department, etc. , produced in tabular form, needs to update statistics every year.
The purpose of maintaining the account is to facilitate the query of the same fault handling method in the future. Most importantly, if your company is going to have an annual review, the auditor should look at your maintenance status and handling methods. -the basic content is; Equipment name, serial number, user department, fault reason, treatment method, replacement spare parts name, etc.