Enter the title of the first line and the following data in "Account" as shown in the figure, and 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 location of everything.
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 in the browse worksheet as shown below. An EXCEL function is used here, which is defined as: taking the specified reference as the reference frame and obtaining 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 changed 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 must be formulated and implemented by enterprises or project departments according to the requirements of "standards". Including construction organization design and special safety construction scheme editing system; Implementation system of safety technical measures plan; * * * 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; No interference measures, etc. ; 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.). ) This account shall be attached if it is inspected by industry safety management departments and enterprises.
6. Safety education
The first is 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 and archived)
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
Fourth, "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, lifting
X. Construction machinery and tools
Note: 1, the column of "acceptance result" 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 production, cost, attendance ... Jin En ... mainly the time, content and quantity of occurrence, or what is the specific account?
Question 4: How to make a ledger? Accounting is to process and summarize daily data. Easy to query, don't think too complicated! For example, classify and summarize the information of manufacturers. Set up 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, all of which are classified and compiled into books for daily reference and superior inspection.
For enterprises, the more important accounts are: financial management account, customer management account, production management account, personnel management account, administrative management account and so on.
Question 6: How to make a ledger 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 "Account" as shown in the figure, and 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 location of everything.
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 in the browse worksheet as shown below. An EXCEL function is used here, which is defined as: taking the specified reference as the reference frame and obtaining 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 changed 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 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 a ledger, I can tell you the most basic and omnipotent methods: First, understand the purpose of the ledger. Generally speaking, the ledger clearly explains the problem in the form of table, which saves a lot of trouble in writing. Fully familiar with and fully understand the things that need to be considered. Secondly, we should know who the account should be opened for and what people should know. If you take all these into account, you can make a good account. Moreover, this is the basic common sense of making watches. If you have any questions, you can contact me.
Question 9: How to do a good job of equipment account In order to facilitate equipment management, a account has been established.
Its contents include: equipment name, model specification, purchase date, service life, depreciation life, asset number, usage status of using department, etc. , produced in tabular form, needs to be updated and counted every year.
Records are maintained for the convenience of querying the same troubleshooting methods in the future. Most importantly, if your company conducts an annual review, the auditor should check 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.