Lift shaft construction drawing auditing method and system based on VBA macro command

Abstract

The invention relates to the technical field of civil construction, in particular to an elevator shaft construction drawing auditing method and system based on a VBA macro command. The problems that in the prior art, when an elevator shaft construction drawing is audited, drawing errors are caused by factors such as insufficient ability and experience of personnel, the on-site construction progress is affected, and project dismounting and changing are caused are solved. The method comprises the following steps: inputting elevator original parameters in Excel according to a drawing identifier and an auditing requirement of a to-be-audited construction drawing so as to obtain elevator shaft construction parameters and elevator demand parameters; carrying out VBA macro command calculation on the elevator shaft construction parameters to obtain elevator actual construction parameters; vBA macro command comparison calculation is conducted on the elevator actual construction parameters and the elevator demand parameters so as to judge whether the elevator actual construction parameters meet the design requirements or not, and a comparison result is output; according to the output comparison result, an adjustment scheme is provided for a construction unit for the comparison result which does not meet the design requirement. The construction drawing auditing speed is high.

Description

Technical Field

[0001] The present invention relates to the field of civil engineering technology, and in particular to a method and system for reviewing elevator shaft construction drawings based on VBA macro commands. Background Art

[0002] The quality of elevator shaft construction depends to a large extent on the quality of elevator detailed drawings. The personnel who draw and review elevator detailed drawings are limited by factors such as lack of experience and professional knowledge. In addition, due to the dispersed responsibility effect, although the drawings have been reviewed by multiple people many times, they are often incomplete and incomplete, and there are still many errors, which affect the progress of on-site construction, cause project demolition and modification, and increase unnecessary construction time and costs.

[0003] The invention patent with application number 202410173376.6 and titled: A system for automatically generating elevator civil engineering drawings and its use method discloses a system for automatically generating elevator civil engineering drawings and its use method. Although it can reduce the errors in manual drawing to a certain extent, since the technology focuses on generating drawings for elevator units, it cannot fully solve the drawing problem from the perspective of actual construction, and still does not solve the above-mentioned problems. At the same time, the efficiency of fully automatic drawing or reviewing drawings is high, but for construction technicians, being familiar with the original data helps to improve construction quality and reduce construction errors, and relying entirely on automated review is not conducive to actual construction. Therefore, a method for reviewing elevator shaft construction drawings is needed to solve the problem in the prior art that when reviewing the elevator shaft construction drawings, errors in the drawings are caused by factors such as lack of personnel ability and experience, which affects the progress of on-site construction and causes project demolition and modification. Summary of the invention

[0004] The purpose of the present invention is to provide an elevator shaft construction drawing review method and system based on VBA macro commands to solve the problems raised in the above background technology.

[0005] To achieve the above object, the present invention provides the following technical solution: a method for reviewing elevator shaft construction drawings based on VBA macro commands, comprising the following steps: S1. According to the drawing identification and review requirements of the construction drawings to be reviewed, enter the original parameters of the elevator in Excel to obtain the elevator shaft construction parameters and elevator demand parameters; S2. performing macro-command calculation on the elevator shaft construction parameters to obtain actual elevator construction parameters; S3, performing macro-command comparison and calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements, and output the comparison results; S4. Based on the output comparison results, for comparison results that do not meet the design requirements, an adjustment plan is proposed to the construction unit. After the construction unit completes the adjustment, steps S1-S3 are re-run until the comparison results that meet the design requirements are output.

[0006] Preferably, in S1, the elevator shaft construction parameters include the number of elevators, the building number, the elevator number, the top building elevation, the hook bottom elevation of the machine roomless elevator, the machine room floor beam bottom or slab bottom elevation of the machine room elevator, the pit bottom structure elevation, the bottom building elevation, the maximum value of the first shaft width positioning, the minimum value of the second shaft width positioning, the maximum value of the first shaft depth and the minimum value of the second shaft depth.

[0007] Preferably, in S1, the elevator requirement parameters include top floor clear height, elevator foundation pit depth, elevator travel, shaft clear width and shaft clear depth.

[0008] Preferably, in S2, when the elevator shaft construction parameters are calculated by VBA macro commands, the items of the actual construction parameters of the elevator correspond to the items of the elevator demand parameters, and the actual construction parameters of the elevator include the actual top floor clear height, the actual elevator foundation pit depth, the actual elevator travel, the actual shaft clear width and the actual shaft clear depth.

[0009] Preferably, in S3, when the actual construction parameters of the elevator and the elevator demand parameters are compared and calculated by VBA macro commands, the items of the actual construction parameters of the elevator are compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output.

[0010] Preferably, the items of the actual construction parameters of the elevator are individually compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output, specifically: S30, taking the value of each item of the elevator demand parameter or the value range of the adjacent value as the comparison value, and performing comparison calculation on the value of each item of the actual construction parameter of the elevator; S31. If the value of the actual construction parameter of the elevator is equal to the comparison value or is within the numerical range of the comparison value, the item is judged to meet the design requirements; if the value of the actual construction parameter of the elevator is less than the comparison value, the item is judged to fail to meet the design requirements; if the value of the actual construction parameter of the elevator is greater than the comparison value, the item is judged to exceed the design requirements; S32. Output the comparison results in Excel according to the judgment results after the comparison calculation. For the projects whose actual construction parameters of the elevator are judged to meet the design requirements, the result of "satisfying the requirements" is output; for the projects whose actual construction parameters of the elevator are judged to not meet the design requirements, the result of "the actual construction parameters of the elevator are insufficient and the design unit needs to adjust" is output; for the projects whose actual construction parameters of the elevator are judged to exceed the design requirements, the result of "the actual construction parameters of the elevator exceed the design and the attention of the elevator unit is required" is output; according to the type of the output comparison results, the cells of the comparison results in Excel are filled with different colors to distinguish them.

[0011] In another aspect, the present invention provides an elevator shaft construction drawing review system based on VBA macro commands, comprising: The parameter input module of the drawings to be reviewed is used to input the original parameters of the elevator in Excel according to the drawing identification and review requirements of the construction drawings to be reviewed, so as to obtain the elevator shaft construction parameters and the elevator demand parameters; An elevator actual construction parameter calculation module, used to perform macro-command calculation on the elevator shaft construction parameters to obtain the elevator actual construction parameters; The comparison module is used to perform macro-command comparison calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements and output the comparison results.

[0012] Preferably, the comparison module includes a top-floor clear height comparison module, an elevator foundation pit depth comparison module, an elevator travel comparison module, a shaft clear width comparison module and a shaft clear depth comparison module.

[0013] Preferably, the elevator shaft construction drawing review system based on VBA macro commands is also provided with a one-key operation module for automatically running the elevator actual construction parameter calculation module and the comparison module, and automatically outputting the comparison results.

[0014] Beneficial effects: Compared with the prior art, the elevator shaft construction drawing review method and system based on VBA macro commands of the present invention have the following significant features: (1) It solves the problem that when drawing and reviewing drawings manually, due to factors such as lack of personnel ability and experience, drawings are incorrect, which affects the progress of on-site construction and causes project demolition and modification, improves construction quality, improves drawing review and construction efficiency, reduces project demolition and modification, reduces the impact on building safety, and avoids unnecessary construction period and cost increase. (2) The review system provided by the present invention only requires the user to manually input the original parameters, and realizes the elevator drawing review by running the corresponding module, which saves tedious calculation and comparison steps, improves work efficiency, and improves the review quality. This improvement is particularly obvious in projects with a large number of elevators. (3) Since the review system of the present invention is simple to operate, it only requires the user to have basic drawing recognition skills, and does not require relevant experience and knowledge such as elevator shaft construction and elevator in-depth drawing review. In addition, the macro command of the present invention can be realized with the help of EXCEL, and the use conditions are low and easy to implement. BRIEF DESCRIPTION OF THE DRAWINGS

[0015] Figure 1 It is a flowchart of the elevator shaft construction drawing review method based on VBA macro command of the embodiment; Figure 2 A schematic diagram of inputting original parameters of the elevator shaft construction drawing review system based on VBA macro commands in the embodiment; Figure 3 It is a schematic diagram of the comparison result output by the elevator shaft construction drawing review system based on VBA macro commands of the embodiment. DETAILED DESCRIPTION

[0016] The technical solution of the present invention is described in detail below with reference to the accompanying drawings, but the protection scope of the present invention is not limited to the embodiments.

[0017] Example: Figure 1 As shown: This embodiment provides an elevator shaft construction drawing review method based on VBA macro commands, comprising the following steps: S1. According to the drawing identification and review requirements of the construction drawings to be reviewed, enter the original parameters of the elevator in Excel to obtain the elevator shaft construction parameters and elevator demand parameters; S2. performing macro-command calculation on the elevator shaft construction parameters to obtain actual elevator construction parameters; S3, performing macro-command comparison and calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements, and output the comparison results; S4. Based on the output comparison results, for comparison results that do not meet the design requirements, an adjustment plan is proposed to the construction unit. After the construction unit completes the adjustment, steps S1-S3 are re-run until the comparison results that meet the design requirements are output.

[0018] In step S1 of this embodiment, the elevator shaft construction parameters include the number of elevators, building number, elevator number, top floor building elevation, hook bottom elevation of elevators without machine room, machine room floor beam bottom or slab bottom elevation of elevators with machine room, pit bottom structure elevation, bottom floor building elevation, first shaft width positioning maximum value, second shaft width positioning minimum value, first shaft depth maximum value and second shaft depth minimum value. The elevator demand parameters include top floor net height, elevator foundation pit depth, elevator travel, shaft net width and shaft net depth. When reviewing the construction drawings to be reviewed in this embodiment, the user can also customize and add elevator demand parameters according to the review requirements, that is, add review parameters.

[0019] In S2 of this embodiment, when the VBA macro command is used to calculate the elevator shaft construction parameters, the items of the actual elevator construction parameters correspond to the items of the elevator demand parameters, wherein the actual elevator construction parameters include the actual top floor clear height, the actual elevator foundation pit depth, the actual elevator travel, the actual shaft clear width and the actual shaft clear depth.

[0020] In addition, in S3 of this embodiment, when the actual construction parameters of the elevator and the elevator demand parameters are compared and calculated by VBA macro commands, the items of the actual construction parameters of the elevator are compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output.

[0021] Furthermore, the items of the actual construction parameters of the elevator are individually compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output, specifically: S30, taking the value of each item of the elevator demand parameter or the value range of the adjacent value as the comparison value, and performing comparison calculation on the value of each item of the actual construction parameter of the elevator; S31. If the value of the actual construction parameter of the elevator is equal to the comparison value or is within the numerical range of the comparison value, the item is judged to meet the design requirements; if the value of the actual construction parameter of the elevator is less than the comparison value, the item is judged to fail to meet the design requirements; if the value of the actual construction parameter of the elevator is greater than the comparison value, the item is judged to exceed the design requirements; S32. Output the comparison result in Excel according to the judgment result after the comparison calculation. For the project of the actual construction parameters of the elevator that are judged to meet the design requirements, the result of meeting the requirements is output; for the project of the actual construction parameters of the elevator that are judged not to meet the design requirements, the result of insufficient actual construction parameters of the elevator is output, and the design unit needs to adjust the result; for the project of the actual construction parameters of the elevator that are judged to exceed the design requirements, the result of the actual construction parameters of the elevator exceeds the design and the elevator unit needs to pay attention to is output; according to the type of output comparison result, the cells of the Excel comparison result are filled with different colors to show the difference. The cell filling color of the comparison result of this embodiment can be selected as white as the output of the actual construction parameters of the elevator that meet the elevator requirements according to the comparison result, and the output of the actual construction parameters of the elevator that are judged not to meet the design requirements can be selected as red to remind the design unit that adjustments are needed, and the project of the actual construction parameters of the elevator that are judged to exceed the design requirements is selected as yellow to remind the elevator construction unit to make adjustments during construction.

[0022] In addition, this embodiment also provides an elevator shaft construction drawing review system based on VBA macro commands, including: The parameter input module of the drawings to be reviewed is used to input the original parameters of the elevator in Excel according to the drawing identification and review requirements of the construction drawings to be reviewed, so as to obtain the elevator shaft construction parameters and the elevator demand parameters; An elevator actual construction parameter calculation module is used to perform VBA macro command calculation on the elevator shaft construction parameters to obtain the elevator actual construction parameters; The comparison module is used to perform VBA macro command comparison calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements and output the comparison results. Among them, the actual construction parameter calculation module of the elevator includes the top clear height calculation module, the elevator foundation pit depth calculation module, the elevator stroke calculation module, the shaft net width calculation module and the shaft net depth calculation module. The comparison module includes the top clear height comparison module, the elevator foundation pit depth comparison module, the elevator stroke comparison module, the shaft net width comparison module and the shaft net depth comparison module. The elevator shaft construction drawing review system based on VBA macro commands also has a one-key operation module, which is used to automatically run the actual construction parameter calculation module and the comparison module of the elevator, and automatically output the comparison results.

[0023] Working principle: When the elevator shaft construction drawing review system based on VBA macro commands of this embodiment is used, the drawings are reviewed according to the elevator shaft construction drawing review method based on VBA macro commands. Figure 2As shown, the user inputs the original parameters into the parameter input module of the drawing to be reviewed to obtain the elevator shaft construction parameters and the elevator demand parameters, and the elevator shaft construction parameters include the number of elevators, the building number, the elevator number, the top building elevation, the hook bottom elevation of the elevator without a machine room, the machine room floor beam bottom or slab bottom elevation of the elevator with a machine room, the pit bottom structure elevation, the bottom building elevation, the maximum value of the first shaft width positioning, the minimum value of the second shaft width positioning, the maximum value of the first shaft depth and the minimum value of the second shaft depth. The elevator demand parameters include the top clear height, the elevator foundation pit depth, the elevator travel, the shaft clear width and the shaft clear depth. Then the user runs the top clear height calculation module to obtain the actual top clear height of each elevator. When the top clear height calculation module of this embodiment uses VBA macro commands for calculation, the macro command code is as follows: Sub TopLevel() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Htopfloor = S.Range("D" & i) Hhook = S.Range("E" & i) Htop = (Hhook - Htopfloor) * 1000 S.Range("F" & i) = Htop Next End Sub.

[0024] The user then runs the "Top Floor Clear Height Comparison" module to compare whether the top floor clear height of each elevator meets the design and elevator installation requirements.

[0025] ① If the top floor clear height is equal to the top floor clear height required by the elevator, the output result is "Meets the requirements" and the cell is filled with white; ② If the top floor clear height is less than the top floor clear height required by the elevator, the output result is "The top floor height is insufficient and needs to be adjusted by the design unit", and the cell is filled in red; ③ If the top floor clear height is greater than the top floor clear height required by the elevator, and the height difference is not less than 1000mm, the output result is "The top floor height is too high, the elevator unit needs to pay attention", and the cell is filled with yellow; ④ If the top floor clear height is greater than the top floor clear height required by the elevator, and the height difference is less than 1000mm, the output result is "satisfied requirements", and the cell is filled with white; The macro command code for the top clear height module is as follows: Sub Top Height Comparison() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Htop = S.Range("F" & i) Htopdemand = S.Range("G" & i) If Abs(Htop - Htopdemand) < 0.1 Then S.Range("H" & i) = "Satisfies the requirements" S.Range("H" & i).Interior.Color = RGB(255, 255, 255) ElseIf Htop < Htopdemand Then S.Range("H" & i) = "The top floor height is insufficient, and the design unit needs to be adjusted" S.Range("H" & i).Interior.Color = RGB(255, 0, 0) ElseIf Htop - Htopdemand >= 1000 Then S.Range("H" & i) = "The top floor is too high, please pay attention to the elevator unit" S.Range("H" & i).Interior.Color = RGB(255, 255, 0) ElseIf Htop - Htopdemand < 1000 Then S.Range("H" & i) = "Satisfies the requirements" S.Range("H" & i).Interior.Color = RGB(255, 255, 255) End If Next End Sub.

[0026] After completing the output of the top floor clear height parameter comparison results, the user will then proceed to the elevator pit depth calculation module in turn to output the actual elevator pit depth of each elevator. The macro command code is as follows: Sub Elevator Pit Depth() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Hpitfloor = S.Range("I" & i) Hgroundfloor = S.Range("J" & i) Hpit = (Hgroundfloor - Hpitfloor) * 1000 S.Range("K" & i) = Hpit Next End Sub.

[0027] Then run the "Elevator Pit Depth Comparison" module to compare whether the depth of each elevator pit meets the design and elevator installation requirements.

[0028] ① If the elevator pit depth is equal to the elevator required elevator pit depth, the output result is "satisfied requirements" and the cell is filled with white; ② If the elevator pit depth is less than the required elevator pit depth, the output result is "the elevator pit depth is insufficient and needs to be adjusted by the design unit", and the cell is filled in red; ③ If the elevator pit depth is greater than the elevator required elevator pit depth, the output result is "the elevator pit depth is greater than the required depth, the elevator unit needs to pay attention to it", and the cell is filled with yellow; The macro command code is as follows: Sub Elevator pit depth comparison () Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Hpit = S.Range("K" & i) Hpitdemand = S.Range("L" & i) If Abs(Hpit - Hpitdemand) < 0.1 Then S.Range("M" & i) = "Meets the requirements" S.Range("M" & i).Interior.Color = RGB(255, 255, 255) ElseIf Hpit < Hpitdemand Then S.Range("M" & i) = "The elevator pit depth is insufficient, and the design unit needs to be adjusted" S.Range("M" & i).Interior.Color = RGB(255, 0, 0) ElseIf Hpit > Hpitdemand Then S.Range("M" & i) = "The elevator pit depth is greater than required, the elevator unit needs to pay attention to it" S.Range("M" & i).Interior.Color = RGB(255, 255, 0) End If Next End Sub.

[0029] Similarly, the user calculates and compares the elevator travel to output whether the actual travel of each elevator meets the design and elevator installation requirements. The user first runs the elevator travel calculation module to output the actual travel of each elevator. The macro command code is as follows: Sub Stroke() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Htopfloor = S.Range("D" & i) Hgroundfloor = S.Range("J" & i) Hoperation = (Htopfloor - Hgroundfloor) S.Range("N" & i) = Hoperation Next End Sub.

[0030] Then run the elevator travel comparison module to compare whether the actual travel of each elevator meets the design and elevator installation requirements.

[0031] ① If the actual travel distance of the elevator is equal to the required travel distance of the elevator, the output result is "satisfied requirements" and the cell is filled with white; ② If the actual travel of the elevator is less than the required elevator pit depth, the output result is "Insufficient travel, design unit needs to adjust", and the cell is filled in red; ③ If the actual travel of the elevator is greater than the required travel of the elevator, the output result is "The travel is greater than the required travel, the elevator unit needs to pay attention", and the cell is filled with yellow; The macro command code is as follows: Sub Stroke Comparison() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n Hoperation = S.Range("N" & i) Hoperationdemand = S.Range("O" & i) If Abs(Hoperation - Hoperationdemand) < 0.1 Then S.Range("P" & i) = "Satisfies the requirements" S.Range("P" & i).Interior.Color = RGB(255, 255, 255) End If If Hoperation < Hoperationdemand Then S.Range("P" & i) = "Insufficient stroke, need to adjust the design unit" S.Range("P" & i).Interior.Color = RGB(255, 0, 0) ElseIf Hoperation > Hoperationdemand Then S.Range("P" & i) = "The travel distance is greater than the demand, the elevator unit needs to pay attention to it" S.Range("P" & i).Interior.Color = RGB(255, 255, 0) End If Next End Sub.

[0032] Finally, the user calculates and compares the net width and net depth of the shaft in turn to output the comparison between the actual shaft construction parameters of each elevator and the required parameters of the elevator to determine whether the elevator shaft design meets the design requirements. The running macro code of the shaft net width and shaft net depth calculation module will not be repeated again. This embodiment mainly describes the macro code and comparison output instructions of the shaft net depth comparison module and the shaft net depth comparison module. The user runs the shaft net width comparison module: ① If the actual net width of the elevator shaft is equal to the required net width of the elevator shaft, the output result is "Meets the requirements" and the cell is marked in white.

[0033] ② If the actual net width of the elevator shaft is smaller than the required net width of the elevator shaft, the output result is "The structure protrudes from the shaft and the design unit needs to be adjusted", and the cell is marked in red.

[0034] ③If the actual net width of the elevator shaft is greater than the required net width of the elevator shaft, the output result is "The net size of the shaft is greater than the requirement, and the elevator unit needs to pay attention", and the cell is marked in yellow.

[0035] The macro command code is as follows: Sub Shaft Net Width Comparison() Dim S Dim n, i, Htopfloor, Hhook, Htopdemand, Hpitfloor, Hgroundfloor,Hpitdemand, Hoperationdemand, Bdemand, Ddemand As Double Dim Htop, Hpit, Hoperation, B, D As Long Set S = Sheets(1) n = 2 + S.Range("A3") For i = 3 To n B = (S.Range("R" & i) - S.Range("Q" & i)) S.Range("S" & i) = B Bdemand = S.Range("T" & i) If Abs(B - Bdemand) < 0.1 Then S.Range("U" & i) = "Satisfy the requirements" S.Range("U" & i).Interior.Color = RGB(255, 255, 255) ElseIf B < Bdemand Then S.Range("U" & i) = "The structure protrudes from the shaft, and the design unit needs to be adjusted" S.Range("U" & i).Interior.Color = RGB(255, 0, 0) ElseIf B > Bdemand Then S.Range("U" & i) = "The net size of the shaft is larger than required, the elevator unit needs to pay attention to it" S.Range("U" & i).Interior.Color = RGB(255, 255, 0) End If Next End Sub.

[0036] Finally, all comparison results are output in the corresponding cells of EXCEL. The user communicates with the relevant units based on the output results. After the adjustment is completed, the corresponding module review is re-run until the output results are all "satisfactory requirements". Please refer to Figure 3 In addition, in order to save the review cycle, the user can directly run the one-key operation module, and the elevator shaft construction drawing review system can automatically execute each operation module in sequence until the comparison result is output. The macro command code of the one-key operation module is as follows: Sub One-click Run() Call top level height calculation Call top level height comparison Call Elevator pit depth calculation Call Elevator pit depth comparison Call Elevator Travel Calculation Call Elevator Travel Comparison Call Calculation of net width of shaft Call Comparison of net width of shaft Call Calculation of net depth of shaft Call Comparison of net depth of shaft End Sub.

[0037] After the elevator shaft construction drawings are reviewed and meet the design requirements, the construction of the elevator shaft project can be carried out.

[0038] As above, although the present invention has been shown and described with reference to specific preferred embodiments, it should not be construed as limiting the present invention itself. Various changes may be made to it in form and detail without departing from the spirit and scope of the present invention as defined in the appended claims.

Claims

1. A method for reviewing elevator shaft construction drawings based on VBA macro commands, characterized in that: The following steps are involved: S1. According to the drawing identification and review requirements of the construction drawings to be reviewed, enter the original parameters of the elevator in Excel to obtain the elevator shaft construction parameters and elevator demand parameters; S2. Perform VBA macro calculation on the elevator shaft construction parameters to obtain actual elevator construction parameters; S3, performing VBA macro command comparison and calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements, and output the comparison results; S4. Based on the output comparison results, for comparison results that do not meet the design requirements, an adjustment plan is proposed to the construction unit. After the construction unit completes the adjustment, steps S1-S3 are re-run until the comparison results that meet the design requirements are output.

2. The elevator shaft construction drawing review method based on VBA macro command according to claim 1 is characterized in that: In S1, the elevator shaft construction parameters include the number of elevators, the building number, the elevator number, the top building elevation, the hook bottom elevation of the machine roomless elevator, the machine room floor beam bottom or slab bottom elevation of the machine room elevator, the pit bottom structure elevation, the bottom building elevation, the maximum value of the first shaft width positioning, the minimum value of the second shaft width positioning, the maximum value of the first shaft depth and the minimum value of the second shaft depth.

3. The elevator shaft construction drawing review method based on VBA macro command according to claim 1 is characterized in that: In S1, the elevator requirement parameters include the top floor clear height, elevator foundation pit depth, elevator travel, shaft clear width and shaft clear depth.

4. The elevator shaft construction drawing review method based on VBA macro command according to claim 3 is characterized in that: In S2, when macro-command calculation is performed on the elevator shaft construction parameters, the items of the actual elevator construction parameters correspond to the items of the elevator demand parameters, and the actual elevator construction parameters include the actual top floor clear height, the actual elevator foundation pit depth, the actual elevator travel, the actual shaft clear width and the actual shaft clear depth.

5. The elevator shaft construction drawing review method based on VBA macro command according to claim 4 is characterized in that: In S3, when the actual construction parameters of the elevator and the elevator demand parameters are compared and calculated by macro commands, the items of the actual construction parameters of the elevator are individually compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output.

6. The elevator shaft construction drawing review method based on VBA macro command according to claim 5 is characterized in that: The items of the actual construction parameters of the elevator are individually compared and calculated with the items of the elevator demand parameters one by one, and the comparison results are output, specifically: S30, taking the value of each item of the elevator demand parameter or the value range of the adjacent value as the comparison value, and performing comparison calculation on the value of each item of the actual construction parameter of the elevator; S31. If the value of the actual construction parameter of the elevator is equal to the comparison value or is within the numerical range of the comparison value, the item is judged to meet the design requirements; if the value of the actual construction parameter of the elevator is less than the comparison value, the item is judged to fail to meet the design requirements; if the value of the actual construction parameter of the elevator is greater than the comparison value, the item is judged to exceed the design requirements; S32. Output the comparison result in Excel according to the judgment result after the comparison calculation. For the project whose actual construction parameters of the elevator are judged to meet the design requirements, the result of "satisfying the requirements" is output; for the project whose actual construction parameters of the elevator are judged to not meet the design requirements, the result of "the actual construction parameters of the elevator are insufficient and the design unit needs to adjust" is output; for the project whose actual construction parameters of the elevator are judged to exceed the design requirements, the result of "the actual construction parameters of the elevator exceed the design and the attention of the elevator unit is required" is output; Depending on the type of output comparison results, the cells of the Excel comparison results are filled with different colors to distinguish them.

7. An elevator shaft construction drawing review system based on VBA macro commands, characterized in that: include: The parameter input module of the drawings to be reviewed is used to input the original parameters of the elevator in Excel according to the drawing identification and review requirements of the construction drawings to be reviewed, so as to obtain the elevator shaft construction parameters and the elevator demand parameters; An elevator actual construction parameter calculation module, used to perform macro-command calculation on the elevator shaft construction parameters to obtain the elevator actual construction parameters; The comparison module is used to perform macro-command comparison calculation on the actual construction parameters of the elevator and the required parameters of the elevator to determine whether the actual construction parameters of the elevator meet the design requirements and output the comparison results.

8. The elevator shaft construction drawing review system based on VBA macro command according to claim 7 is characterized in that: The actual elevator construction parameter calculation module includes a top-floor clear height calculation module, an elevator foundation pit depth calculation module, an elevator travel calculation module, a shaft clear width calculation module, and a shaft clear depth calculation module.

9. The elevator shaft construction drawing review system based on VBA macro command according to claim 7 is characterized in that: The comparison module includes a top-level clear height comparison module, an elevator foundation pit depth comparison module, an elevator travel comparison module, a hoistway clear width comparison module, and a hoistway clear depth comparison module.

10. The elevator shaft construction drawing review system based on VBA macro command according to claim 7, characterized in that: The elevator shaft construction drawing review system based on VBA macro commands is also provided with a one-key operation module for automatically running the elevator actual construction parameter calculation module and the comparison module, and automatically outputting the comparison results.

Images