Method, system and device for optimizing riser curve of escalator steps based on VBA
Through the VBA-based automation method, the kick surface curve of the escalator step is optimized, and the problem of design dependence on experience values and standard specifications in the prior art is solved, and more efficient and accurate design is achieved, reducing design deviations and manual calculation time is applicable. Escalator design for different usage environments.
Patent Information
- Application Number
- CN202410950735.4
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2024-07-16
- Publication Date
- 2024-11-22
- Estimated Expiration
- 2044-07-16
AI Technical Summary
The kick curve design of existing escalator steps depends on experience values and standard specifications, making it difficult to predict and analyze the operation conditions in different usage environments in advance. The design process is complex and time-consuming, making it difficult to compare and analyze multiple parameters. Causes design deviation and inefficiency.
Using VBA-based automation method, by obtaining the sample points and sample points coordinates of the step kick surface, a reference kick surface curve is generated, and the sample points are expanded according to the preset range and spacing, the extended kick surface curve is calculated and generated, and the target curve is selected to realize the kick. The preferred design of surface curves reduces manual calculation and repeated test time.
It improves design efficiency and accuracy, and can predict and analyze escalator operating parameters in different usage environments in advance according to actual needs, reduce design deviations, and meet the design requirements of different application scenarios.
Smart Images

Figure CN118484958B_ABST
Abstract
Description
Technical Field
[0001] The present invention relates to the technical field of escalators, and in particular to a VBA-based method, system and device for optimizing a riser curve of an escalator step. Background Art
[0002] The riser curve of the escalator step is the design curve of the transition area between the tread and the riser. It plays a vital role in the operation of the escalator. It not only affects the stability and durability of the escalator, but also directly affects the safety of passengers. At the same time, a reasonable riser curve is also conducive to accurately controlling the meshing gap between two adjacent steps, effectively preventing the treads and risers of adjacent steps from colliding or rubbing during the operation of the escalator, effectively reducing mechanical wear and extending the service life of the equipment.
[0003] The riser curves of existing escalator steps are mainly designed based on industry standards and experience. On the one hand, designers will determine the parameters of the riser curve based on standard specifications and years of engineering experience; on the other hand, after the design is completed, the escalator will undergo a large number of tests and verifications in actual applications, and through actual use feedback data, the parameters of the riser curve will be continuously optimized and adjusted to provide case references for subsequent designs.
[0004] Since the existing riser curve is designed based on experience and standard specifications, it is difficult to predict and analyze the operation of escalators in different usage environments in advance. If there is a design deviation, it will be difficult to correct it later. In addition, since the adjustment of the riser curve parameters during the design process makes the design process complicated and time-consuming, it is difficult to compare and analyze multiple parameters, and it is impossible to select a better design solution from adjacent parameters. Summary of the invention
[0005] The purpose of the present invention is to provide a VBA-based method, system and device for optimizing the riser curve of escalator steps, to automate the calculation and optimization process of the riser curve based on VBA design, to reduce the time of manual calculation and repeated experiments, and to improve the design efficiency and accuracy.
[0006] To achieve the above object, the present invention discloses the following technical solution:
[0007] On one hand, the present invention provides a method for optimizing the riser curve of an escalator step based on VBA, comprising the following steps:
[0008] Get the sample points and coordinates of the step riser;
[0009] Selecting a plurality of sample points from the sample points of the step riser as curve sample points, and calculating and generating a reference riser curve based on the coordinates of the curve sample points;
[0010] Taking each curve sample point as a reference, sample points are extended around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and an extended riser curve is generated based on coordinate calculation of the extended sample points;
[0011] A target riser curve is selected from the extended riser curves.
[0012] In the above preferred method, obtaining the sample points and sample point coordinates of the step riser includes:
[0013] Input preset parameters, including step parameters, chain parameters and guide rail parameters, wherein the step parameters include the horizontal distance a from the end point of the rear edge of the step tread to the center of the step main axis, the vertical distance b from the end point of the rear edge of the step tread to the center of the step main axis, and the horizontal gap d between adjacent steps; the chain parameters include the number of chain links N and the chain link pitch p of each step; the guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle of the escalator ;
[0014] A longitudinal distribution interval of sample points of the step riser is set, and based on the longitudinal distribution interval, sample points and sample point coordinates of the step riser are obtained.
[0015] Optionally, in the above preferred method, the curve sample points include the starting point sample points, the midpoint sample points and the end point sample points among the sample points of the step riser.
[0016] The above preferred method, taking each curve sample point as a reference, and performing sample point expansion around the curve sample point according to a preset range and a preset spacing to generate extended sample points, comprises:
[0017] Taking the starting point sample point as a reference, sample points are expanded around the starting point sample point according to a preset range and a preset spacing to generate a first group of expanded sample points, the number of which is recorded as n1;
[0018] Taking the midpoint sample point as a reference, sample points are expanded around the midpoint sample point according to a preset range and a preset spacing to obtain a second group of expanded sample points, the number of which is recorded as n2;
[0019] Taking the end point sample point as a reference, sample points are extended around the end point sample point according to a preset range and a preset interval to obtain a third group of extended sample points, the number of which is recorded as n3.
[0020] The above-mentioned preferred method, wherein the calculation based on the coordinates of the extended sample points is used to generate the extended riser curve, comprises: extracting one sample point from each of the first group of extended sample points, the second group of extended sample points and the third group of extended sample points, and calculating the center coordinates and radius of the arc in which the sample point is located based on the coordinates of the sample point, and generating a corresponding extended riser curve according to the center coordinates and the radius.
[0021] In the above preferred method, the number of the extended riser curves is .
[0022] Optionally, in the above preferred method, the longitudinal distribution interval of the sample points of the step riser is 0.2mm, 0.8mm, 1.6mm or 3.2mm.
[0023] Another aspect of the present invention provides a VBA-based escalator step riser curve optimization system, comprising:
[0024] A sample point acquisition module is used to obtain sample points and sample point coordinates of the step riser;
[0025] A curve generating module, used for selecting a plurality of sample points from the sample points of the step riser and recording them as curve sample points, and generating a reference riser curve based on the coordinates of the curve sample points;
[0026] A curve extension module, for taking each curve sample point as a reference, performing sample point extension around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and calculating and generating an extended riser curve based on the coordinates of the extended sample points;
[0027] The curve optimization module is used to select a target riser curve from the extended riser curves.
[0028] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein when the processor executes the computer program, the VBA-based method for optimizing the riser curve of an escalator step is implemented.
[0029] In addition, the present invention also provides a computer-readable storage medium, on which a computer program is stored. When the computer program is executed by a processor, the VBA-based method for optimizing the riser curve of an escalator step is implemented as described above.
[0030] The effects provided in the content of the invention are only the effects of the embodiments, not all the effects of the invention. One of the above technical solutions has the following advantages or beneficial effects:
[0031] The technical solution provided by the embodiment of the present disclosure automatically calculates the reference riser curve based on the step riser sample points, realizes the automated processing of the step riser curve, and improves the design efficiency. The solution takes each curve sample point as a reference, automatically expands the sample point and calculates the extended riser curve based on a preset range and preset spacing around the curve sample point, and then selects the target riser curve from multiple adjacent extended riser curves, thereby realizing the optimal design of the riser curve, greatly reducing the time for manual calculation and repeated experiments, and improving the design efficiency and accuracy. At the same time, the solution can also perform different sample point settings according to actual needs, predict and analyze the operating parameters of the escalator under different usage environments in advance, meet the design requirements of different application scenarios, reduce design deviations, and has high practical value and application prospects. BRIEF DESCRIPTION OF THE DRAWINGS
[0032] The accompanying drawings, which are incorporated in and constitute a part of the specification, illustrate embodiments consistent with the present application and, together with the description, serve to explain the principles of the present application.
[0033] Figure 1 A schematic flow chart of a method for optimizing the riser curve of an escalator step based on VBA provided in one embodiment of the present application;
[0034] Figure 2 A schematic flow chart of a method for optimizing the riser curve of an escalator step based on VBA provided in another embodiment of the present application;
[0035] Figure 3 for Figure 2 Schematic diagram of the specific implementation process of step S240;
[0036] Figure 4 A schematic diagram of a partially extended riser curve of an escalator step provided in one embodiment of the present application;
[0037] Figure 5 A schematic diagram of the structure of a VBA-based escalator step riser curve optimization system according to an embodiment of the present application;
[0038] Figure 6 A schematic diagram of the structure of an electronic device provided in one embodiment of the present application;
[0039] Reference numerals:
[0040] 410-starting point, 411-first group of extended points, 420-midpoint point, 421-second group of extended points, 430-end point, 431-third group of extended points, 440-reference riser curve, 450-extended riser curve;
[0041] 510 - sample point acquisition module, 520 - curve generation module, 530 - curve expansion module, 540 - curve optimization module;
[0042] 610 - input unit, 620 - memory, 630 - processor, 640 - output unit. DETAILED DESCRIPTION
[0043] In order to make the purpose, technical solution and advantages of the present invention more clearly understood, the present invention is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present invention and are not intended to limit the present invention.
[0044] It should be noted that references to "one embodiment", "embodiment", "example embodiment", etc. in this specification refer to the embodiment being described which may include specific features, structures or characteristics, but not every embodiment must include these specific features, structures or characteristics. In addition, such expressions do not refer to the same embodiment. Furthermore, when describing specific features, structures or characteristics in conjunction with an embodiment, whether or not there is an explicit description, it is indicated that incorporating such features, structures or characteristics into other embodiments is within the knowledge of those skilled in the art.
[0045] In addition, certain words are used in the specification and subsequent claims to refer to specific components or parts. Those with ordinary knowledge in the relevant field should understand that manufacturers can use different nouns or terms to refer to the same component or part. This specification and subsequent claims do not use differences in names as a way to distinguish components or parts, but use differences in the functions of components or parts as the criteria for distinction. "Including" and "including" mentioned throughout the specification and subsequent claims are open-ended terms and should be interpreted as "including but not limited to". In addition, the word "connected" here includes any direct and indirect electrical connection means. Indirect electrical connection means include connection through other devices.
[0046] Since the riser curve of existing escalator steps is mainly designed based on engineering experience and manual adjustment, there are problems such as low design efficiency and difficulty in parameter prediction analysis and optimization. In order to solve the shortcomings of traditional design methods, the following embodiment provides a VBA-based riser curve optimization method, system and equipment for escalator steps, which uses computer-aided design technology and combines parametric design ideas to achieve automatic calculation and optimization of step riser curves, effectively reduce design deviations, and improve design efficiency and design accuracy.
[0047] refer to Figure 1 , Figure 1A schematic flow chart of a method for optimizing the riser curve of an escalator step based on VBA is shown in an embodiment of the present application. The method comprises the following steps:
[0048] S110, obtaining sample points and sample point coordinates of the step riser.
[0049] Specifically, in this embodiment, obtaining the sample points and sample point coordinates of the step riser includes:
[0050] Input preset parameters, including step parameters, chain parameters and guide rail parameters, among which step parameters include the horizontal distance a from the end point of the rear edge of the step tread to the center of the step main axis, the vertical distance b from the end point of the rear edge of the step tread to the center of the step main axis, and the horizontal gap d between adjacent steps; chain parameters include the number of chain links N and the chain link pitch p for each step; guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle of the escalator ;
[0051] The longitudinal distribution interval of the sample points of the step riser is set, and based on the longitudinal distribution interval, the sample points and sample point coordinates of the step riser are obtained.
[0052] S120, selecting a plurality of sample points from the sample points of the step riser and recording them as curve sample points, and generating a reference riser curve based on the coordinate calculation of the curve sample points.
[0053] S130 , taking each curve sample point as a reference, expanding the sample points around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and calculating and generating an extended riser curve based on the coordinates of the extended sample points.
[0054] S140. Select a target riser curve from the extended riser curves.
[0055] As mentioned above, the existing escalator riser curve design method is designed based on engineering experience and manual adjustment. It is difficult to predict and analyze the operation of the escalator in different usage environments in advance, and it is difficult to compare and analyze multiple adjacent parameters. In this embodiment, the calculation and optimization process of the entire riser curve can be automated, and data that meets the design requirements can be quickly screened out to achieve efficient, accurate and optimal design of the riser curve, thereby greatly reducing the time for manual calculation and repeated experiments, and improving design efficiency and accuracy.
[0056] In order to describe the technical solution of the present invention in more detail, Figure 2 The embodiment specifically illustrates the process of optimizing the riser curve of escalator steps.
[0057] refer to Figure 2 , Figure 2A schematic flow chart of a method for optimizing the riser curve of an escalator step based on VBA is shown in another embodiment of the present application. The method comprises the following steps:
[0058] S210, creating an interactive interface based on VBA, and inputting preset parameters in the interactive interface, wherein the preset parameters include step parameters, chain parameters, and guide rail parameters.
[0059] Specifically, the step parameters include the horizontal distance a from the end point of the step tread rear edge to the center of the step main axis, the vertical distance b from the end point of the step tread rear edge to the center of the step main axis, and the horizontal gap d between adjacent steps. Chain parameters include the number of chain links N and the chain link pitch p for each step. Guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle of the escalator. .
[0060] S220. Setting the longitudinal distribution interval of the sample points of the step riser in the VBA interactive interface to obtain the coordinates of the sample points of the step riser.
[0061] Specifically, in this embodiment, the longitudinal distribution intervals of the sample points of the step riser are set to four types: 0.2mm, 0.8mm, 1.6mm, and 3.2mm. One of them can be selected according to the actual situation to generate the sample point coordinates of the step riser. Of course, the longitudinal distribution interval of the sample points can also be set to other values according to actual needs. The smaller the longitudinal distribution interval of the sample points, the more corresponding step riser sample points will be generated. For example, when the step chain link is located in the horizontal section of the guide rail, the main axis center of the step is taken as the coordinate origin, and the vertical coordinate of the sample point [P0, P1, P2, ..., Pn] of the step riser is Y P0 =b,Y P1 =bt,Y P2 =b-2 t,……,Y Pn =bn t, where t represents the longitudinal distribution interval of the sample points. According to the design equation of the step kick plate in the China Elevator Association standard "Technical Specifications for Escalator Steps", the corresponding horizontal coordinate can be calculated from the vertical coordinate of the step riser sample point, and then the coordinates of the sample point on the step riser can be obtained.
[0062] S230, selecting three sample points of the step riser in the VBA interactive interface and recording them as curve sample points, and generating a reference riser curve based on the coordinates of the curve sample points.
[0063] In this embodiment, the curve sample points are selected as the starting point sample point, the midpoint sample point and the end point sample point in the sample points of the step riser. Then, based on the coordinates of the starting point sample point, the midpoint sample point and the end point sample point, the center coordinates and the radius of the arc where they are located are calculated, and the corresponding arc curve can be generated according to the center coordinates and the radius, which is the reference riser curve. Of course, in the VBA interactive interface, the reference riser curve can also be calculated and generated by manually inputting the sample point coordinates, taking the average value of the sample point X coordinates or other methods, and the present application is not limited to this.
[0064] S240, taking each curve sample point as a reference in the VBA interactive interface, expanding the sample points around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and generating an extended riser curve based on the coordinate calculation of the extended sample points.
[0065] Specifically, Figure 3 As shown, in this embodiment, step S240 includes the following steps:
[0066] S241, taking the starting point sample point as a reference, expanding the sample points around the starting point sample point according to a preset range and a preset spacing, to generate a first group of extended sample points, the number of which is recorded as n1;
[0067] In this embodiment, the coordinates of the starting point sample point are (341.2, 108.0), and the sample points are expanded along the X axis around the starting point sample point, and the Y coordinate remains unchanged. The preset range is the X coordinate interval, which is , the preset spacing is 0.2. That is, within the preset range By taking a sample point every preset interval of 0.2, the first set of extended sample points can be generated, namely (340.8, 108.0), (341.0, 108.0), and (341.2, 108.0).
[0068] S242, taking the midpoint sample point as a reference, expanding the sample points around the midpoint sample point according to a preset range and a preset spacing to obtain a second group of extended sample points, the number of which is recorded as n2;
[0069] In this embodiment, the coordinates of the midpoint sample point are (330.61, 28.0), and the sample points are expanded along the X axis around the midpoint sample point, and the Y coordinate remains unchanged. The preset range is the X coordinate interval, which is , the preset spacing is 0.2. That is, within the preset range By taking a sample point every preset interval of 0.2, the second set of extended sample points can be generated, namely (330.21, 28.0), (330.41, 28.0), and (330.61, 28.0).
[0070] S243, taking the end point sample point as a reference, expanding the sample points around the end point sample point according to a preset range and a preset spacing, to obtain a third group of extended sample points, the number of which is recorded as n3;
[0071] In this embodiment, the coordinates of the end point sample point are (308.51, -49.58), and the sample points are expanded along the X axis around the end point sample point, and the Y coordinate remains unchanged. The preset range is the X coordinate interval, which is , the preset spacing is 0.2. That is, within the preset range By taking a sample point every preset interval of 0.2, the third set of extended sample points can be generated, namely (308.11, -49.58), (308.31, -49.58), and (308.51, -49.58).
[0072] S244, randomly select a sample point from the first group of extended sample points, the second group of extended sample points and the third group of extended sample points respectively, and calculate the center coordinates and radius of the arc where the sample point is located based on the coordinates of the sample point, and generate a corresponding arc curve according to the center coordinates and radius, which is the extended riser curve.
[0073] After the above steps, a sample point is randomly selected from the first group of extended sample points, the second group of extended sample points, and the third group of extended sample points respectively by using the method of full extraction. The number of extended riser curves generated is Of course, it should be noted that the selection of the reference sample point, the preset range and the preset spacing may also be selected as other values according to the actual situation, and the present application is not limited thereto.
[0074] refer to Figure 4 The figure shows a schematic diagram of a partially extended riser curve of the escalator step in this embodiment. The sample points are extended based on the starting point sample point 410 of the reference riser curve 440 to obtain a first group of extended sample points 411; the sample points are extended based on the midpoint sample point 420 of the reference riser curve to obtain a second group of extended sample points 421; the sample points are extended based on the end point sample point 430 of the reference riser curve to obtain a third group of extended sample points 430. One sample point is extracted from each of the first group of extended sample points 411, the second group of extended sample points 421 and the third group of extended sample points 431 to generate a corresponding extended riser curve 450. In the figure, R1, R2, R3 and Rn respectively represent the curve radii of the corresponding extended riser curves.
[0075] In the VBA interactive interface, the corresponding extended riser curve table can be automatically calculated and generated according to the input preset parameters. For example, in one embodiment, the parameters of the extended riser curve are obtained according to the preset parameters as shown in Table 1 below. In Table 1, the coordinates of the starting point sample point are (341.2, 108.0), and the corresponding preset range is , the preset spacing is 0.2, and n1=3. The coordinates of the midpoint sample point are (330.61, 28.0), and the corresponding preset range is , the preset spacing is 0.2, and n2=3. The coordinates of the end point sample are (308.51, -49.58), and the corresponding preset range is , the preset spacing is 0.2, and n3=3. The number of extended riser curves generated by VBA is , the specific parameters are as follows. In the following table, X1 and Y1 represent the abscissa and ordinate of the first group of extended sample points respectively; X2 and Y2 represent the abscissa and ordinate of the second group of extended sample points respectively; X3 and Y3 represent the abscissa and ordinate of the third group of extended sample points respectively; X0 and Y0 represent the abscissa and ordinate of the center of the kick plate respectively:
[0076]
[0077] S250. Filter the extended riser curves that meet the requirements in the VBA interactive interface, and then select the target riser curve.
[0078] Specifically, in the VBA interactive interface, the parameter data table of the extended kick surface curve that meets the requirements can be screened out through data analysis. According to the national standard "Safety Specifications for the Manufacture and Installation of Escalators and Moving Walkways", the meshing gap between the escalator step kick plate and the adjacent steps shall not exceed 6 mm. In actual engineering applications, after a large amount of actual data testing and research, it was found that when the step gap is between 4 and 4.5 mm, better results can be achieved in terms of safety and passenger experience. As shown in Table 2 below, the parameter data of the minimum step gap greater than or equal to 4 and the maximum step gap less than or equal to 4.5 in Table 1 are screened. Then further analyze and select the target kick surface curve from Table 2. Of course, it should be noted that in some embodiments, the screening range of the step gap can also select other values depending on the actual situation, and the present application is not limited to this.
[0079]
[0080] In some cases, if the generated extended riser curve does not meet the design requirements well, the parameters can be readjusted to generate a new set of riser curve data, and further select better design parameters that meet the requirements.
[0081] In the specific implementation, the corresponding partial program algorithm of this embodiment is as follows:
[0082] Dim X1, Y1, X2, Y2, X3, Y3, RR, i, j, k, k1 As Integer, k2 As Integer, k3 As Integer, g1 As Single, g2 As Single, g3 As Single, U1, u, Arr() As Double, H1, L1, Ar1, T_max As Double, T_min As Double
[0083] U1 = 1
[0084] k1 = Round((TextBox2.Value - TextBox1.Value) / TextBox10.Value)
[0085] g1 = Round(TextBox2.Value - TextBox1.Value - TextBox10.Value k1, 4)
[0086] If g1>0 Then
[0087] k1 = k1 + 1
[0088] End If
[0089] k2 = Round((TextBox5.Value - TextBox4.Value) / TextBox10.Value)
[0090] g2 = Round(TextBox5.Value - TextBox4.Value - TextBox10.Value k2,4)
[0091] If g2>0 Then
[0092] k2 = k2 + 1
[0093] End If
[0094] ……
[0095] Arr(U1, 1) = U1
[0096] Arr(U1, 2) = Text_点01X.Value
[0097] Arr(U1, 3) = b - Text_Point01Y.Value
[0098] Arr(U1, 4) = Text_point02X.Value
[0099] Arr(U1, 5) = b - Text_Point02Y.Value
[0100] Arr(U1, 6) = Text_Point03X.Value
[0101] Arr(U1, 7) = b - Text_point03Y.Value
[0102] Arr(U1, 8) = Sheets("sheet3").Range("B8") 'Record: Current arc parameters - X coordinate of the center
[0103] Arr(U1, 9) = Sheets("sheet3").Range("C8") 'Record: Current arc parameters - Y coordinate of the center
[0104] Arr(U1, 10) = Sheets("sheet3").Range("D8") 'Record: Current arc parameters - radius
[0105] Arr(U1, 11) = T_min 'Record: the current minimum step gap
[0106] Arr(U1, 12) = T_max 'Record: the current maximum step gap value
[0107] U1 = U1 + 1
[0108] Next k
[0109] Next
[0110] Next i
[0111] …
[0112] 'Add wireframe to area 1
[0113] Dim Ar As Range, Br As Range
[0114] Set Ar = Sheets("sheet5").Cells(1, 1).Resize(2, UBound(Arr,2))
[0115] Set Br = Sheets("sheet5").Cells(3, 1).Resize(UBound(Arr),UBound(Arr, 2))
[0116] With Ar.Borders
[0117] .LineStyle = xlContinuous
[0118] .Weight = xlThin
[0119] .ColorIndex = 1
[0120] End With
[0121] With Br.Borders
[0122] .LineStyle = xlContinuous
[0123] .Weight = xlThin
[0124] .ColorIndex = 1
[0125] End With
[0126] Ar.BorderAround xlContinuous, xlMedium, 5
[0127] Br.BorderAround xlContinuous, xlMedium, 5
[0128] Set Ar = Nothing
[0129] Set Br = Nothing
[0130] CheckBox3.Value = True
[0131] CheckBox4.Value = True
[0132] CheckBox5.Value = True
[0133] TextBox11.Enabled = True
[0134] TextBox11.Value = 2
[0135] TextBox12.Enabled = True
[0136] TextBox12.Value = 4.5
[0137] Optimize data. Enabled = True
[0138] End Sub
[0139] In this embodiment, through the VBA interactive interface design, it is convenient to automatically generate sample points and calculate riser curves according to preset parameters, thereby realizing the automated processing of step riser curves and improving design efficiency. By setting the preset range and spacing of sample point extension in the VBA interactive interface, and automatically generating the extended riser curve, and selecting the optimal target curve, the optimal design of the riser curve is realized, which greatly reduces the time of manual calculation and repeated experiments, and improves the design efficiency and accuracy. At the same time, users can select different parameters according to actual conditions, predict and analyze the operating parameters of escalators under different usage environments in advance, and meet the design requirements of different application scenarios. Therefore, the VBA-based escalator step riser curve optimization method of this embodiment can effectively improve the efficiency and accuracy of step riser design, reduce the workload of manual operation, and reduce design deviations. It has high practical value and broad application prospects.
[0140] It should be noted that, for the method embodiments, for the sake of simplicity, they are all expressed as a series of action combinations, but those skilled in the art should be aware that the embodiments of the present application are not limited by the described order of actions, because according to the embodiments of the present application, certain steps can be performed in other orders or simultaneously. Secondly, those skilled in the art should also be aware that the embodiments described in the specification are all preferred embodiments, and the actions involved are not necessarily required by the embodiments of the present application.
[0141] refer to Figure 5 , Figure 5 The schematic diagram of the structure of the riser curve optimization system of the escalator step based on VBA provided in one embodiment of the present application is shown. The optimization system can be used to realize the optimization design of the riser curve of the escalator step. The optimization system described below can be referred to in correspondence with the optimization method described above. The optimization system includes:
[0142] The sample point acquisition module 510 is used to acquire the sample points and sample point coordinates of the step riser;
[0143] A curve generating module 520, configured to select a plurality of sample points from the sample points of the step riser and record them as curve sample points, and calculate and generate a reference riser curve based on the coordinates of the curve sample points;
[0144] The curve extension module 530 is used to take each curve sample point as a reference, perform sample point extension around the curve sample point according to a preset range and a preset spacing to generate an extended sample point, and calculate and generate an extended riser curve based on the coordinates of the extended sample point;
[0145] The curve optimization module 540 is used to select a target riser curve from the extended riser curves.
[0146] Specifically, the sample point acquisition module 510 acquires the sample points and sample point coordinates of the step riser, including:
[0147] Input preset parameters, including step parameters, chain parameters and guide rail parameters, among which step parameters include the horizontal distance a from the end point of the rear edge of the step tread to the center of the step main axis, the vertical distance b from the end point of the rear edge of the step tread to the center of the step main axis, and the horizontal gap d between adjacent steps; chain parameters include the number of chain links N and the chain link pitch p for each step; guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle of the escalator ;
[0148] The longitudinal distribution interval of the sample points of the step riser is set, and based on the longitudinal distribution interval, the sample points and sample point coordinates of the step riser are obtained.
[0149] Preferably, the curve sample points selected by the curve generating module 520 are the starting point sample point, the midpoint sample point and the end point sample point among the sample points of the step riser.
[0150] Optionally, the curve extension module 530 includes:
[0151] A first expansion unit is used to expand sample points around the starting sample point according to a preset range and a preset spacing based on the starting sample point to generate a first group of expanded sample points;
[0152] A second expansion unit is used to expand the sample points around the midpoint sample point according to a preset range and a preset spacing based on the midpoint sample point to obtain a second group of expanded sample points;
[0153] A third expansion unit is used to expand the sample points around the end point sample point according to a preset range and a preset interval based on the end point sample point to obtain a third group of expanded sample points;
[0154] The curve extension unit is used to extract a sample point from each of the first group of extended sample points, the second group of extended sample points and the third group of extended sample points, and calculate the center coordinates and radius of the arc where the sample point is located based on the coordinates of the extracted sample point, and generate a corresponding extended riser curve according to the center coordinates and radius.
[0155] Furthermore, if the current extended riser curve generated by the system cannot well meet the design requirements, the sample point acquisition module 510 can be used to readjust the parameters to generate a new set of riser curve data, from which better design parameters that meet the requirements can be selected.
[0156] Regarding the processes not described in detail in the riser curve optimization system in this embodiment, reference may be made to the relevant parts in the above-mentioned riser curve optimization method embodiment, which will not be described in detail here.
[0157] The present application also provides an electronic device, such as Figure 6 As shown, the electronic device may include an input unit 610, a memory 620, a processor 630 and an output unit 640. The memory 620 stores program instructions that can be run on the processor 630, and the processor 630 calls the program instructions to execute the methods and / or technical solutions based on the aforementioned multiple embodiments. The electronic device may be a mobile terminal device such as a mobile phone or a computer. For the processes not described in detail in the electronic device in this embodiment, reference may be made to the relevant parts in the above-mentioned embodiment of the preferred method for the riser curve, which will not be repeated here.
[0158] In addition, the embodiment of the present application also provides a computer-readable storage medium for storing execution Figure 1 or Figure 2 Any computer program of a VBA-based method for optimizing the riser curve of an escalator step. For example, a computer program instruction, when executed by a computer, can call or provide the method and / or technical solution according to the present application through the operation of the computer. The program instruction for calling the method of the present application may be stored in a fixed or removable storage medium, and / or transmitted through a data stream in a broadcast or other signal-bearing medium and / or stored in a storage medium that runs according to the program instruction.
[0159] The above is a detailed introduction to the VBA-based escalator step riser curve optimization method, system and equipment provided in the embodiments of the present application. The various embodiments in the specification are described in a progressive manner, and each embodiment focuses on the differences from other embodiments. The same and similar parts between the various embodiments can be referenced to each other. For the equipment disclosed in the embodiment, since it corresponds to the method disclosed in the embodiment, the description is relatively simple, and the relevant parts can be referred to the method part description. It should be pointed out that for ordinary technicians in this technical field, without departing from the principles of the present application, several improvements and modifications can be made to the present application, and these improvements and modifications also fall within the scope of protection of the claims of the present application.
[0160] Obviously, those skilled in the art should understand that the above modules or steps of the present application can be implemented by a general computing device, they can be concentrated on a single computing device, or distributed on a network composed of multiple computing devices, and optionally, they can be implemented by a program code executable by a computing device, so that they can be stored in a storage device and executed by the computing device, or they can be made into individual integrated circuit modules, or multiple modules or steps therein can be made into a single integrated circuit module for implementation. In this way, the present application is not limited to any specific combination of hardware and software.
[0161] Although the present application has been described in detail above with general descriptions and specific embodiments, it is obvious to those skilled in the art that some modifications or improvements may be made to the present application. Therefore, these modifications or improvements made without departing from the spirit of the present application all fall within the scope of protection claimed in the present application.
Claims
1. The VBA-based method for optimizing the riser curve of escalator steps is characterized by: The following steps are involved: Obtaining sample points and sample point coordinates of the step riser, including: inputting preset parameters, including step parameters, chain parameters and guide rail parameters, wherein the step parameters include the horizontal distance a from the end point of the rear edge of the step tread to the center of the step main axis, the vertical distance b from the end point of the rear edge of the step tread to the center of the step main axis, and the horizontal gap d between adjacent steps; the chain parameters include the number of chain links N and the chain link pitch p of each step; the guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle φ of the escalator; setting the longitudinal distribution interval of the sample points of the step riser, and obtaining the sample points and sample point coordinates of the step riser based on the longitudinal distribution interval; Selecting a plurality of sample points from the sample points of the step riser as curve sample points, and calculating and generating a reference riser curve based on the coordinates of the curve sample points; Taking each curve sample point as a reference, sample points are extended around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and an extended riser curve is generated based on coordinate calculation of the extended sample points; A target riser curve is selected from the extended riser curves.
2. The method according to claim 1, characterized in that: The curve sample points include a starting point sample point, a midpoint sample point and an end point sample point among the sample points of the step riser.
3. The method according to claim 2, characterized in that The step of taking each curve sample point as a reference and performing sample point expansion around the curve sample point according to a preset range and a preset spacing to generate an extended sample point comprises: Taking the starting point sample point as a reference, sample points are expanded around the starting point sample point according to a preset range and a preset spacing to generate a first group of expanded sample points, the number of which is recorded as n1; Taking the midpoint sample point as a reference, sample points are expanded around the midpoint sample point according to a preset range and a preset spacing to obtain a second group of expanded sample points, the number of which is recorded as n2; Taking the end point sample point as a reference, sample points are extended around the end point sample point according to a preset range and a preset interval to obtain a third group of extended sample points, the number of which is recorded as n3.
4. The method according to claim 3, characterized in that The step of calculating and generating an extended riser curve based on the coordinates of the extended sample points includes: A sample point is respectively extracted from the first group of extended sample points, the second group of extended sample points and the third group of extended sample points, and the center coordinates and radius of the arc where the sample point is located are calculated based on the coordinates of the extracted sample point, and a corresponding extended riser curve is generated according to the center coordinates and the radius.
5. The method according to claim 4, characterized in that The number of extended riser curves is 。 6. The method according to claim 1, characterized in that The longitudinal distribution intervals of the sample points of the step riser are 0.2 mm, 0.8 mm, 1.6 mm or 3.2 mm.
7. The VBA-based escalator step riser curve optimization system is characterized by: include: The sample point acquisition module is used to obtain the sample points and sample point coordinates of the step riser, including: inputting preset parameters, including step parameters, chain parameters and guide rail parameters, wherein the step parameters include the horizontal distance a from the end point of the rear edge of the step tread to the center of the step main axis, the vertical distance b from the end point of the rear edge of the step tread to the center of the step main axis and the horizontal gap d between adjacent steps; the chain parameters include the number of chain links N and the chain link pitch p of each step; the guide rail parameters include the curvature radius R of the transition arc of the escalator guide rail and the maximum inclination angle φ of the escalator; setting the longitudinal distribution interval of the sample points of the step riser, and obtaining the sample points and sample point coordinates of the step riser based on the longitudinal distribution interval; A curve generating module, used for selecting a plurality of sample points from the sample points of the step riser and recording them as curve sample points, and generating a reference riser curve based on the coordinates of the curve sample points; A curve extension module, for taking each curve sample point as a reference, performing sample point extension around the curve sample point according to a preset range and a preset spacing to generate extended sample points, and calculating and generating an extended riser curve based on the coordinates of the extended sample points; The curve optimization module is used to select a target riser curve from the extended riser curves.
8. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the computer program, the VBA-based method for optimizing the riser curve of an escalator step according to any one of claims 1 to 6 is implemented.
9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the VBA-based method for optimizing the riser curve of an escalator step according to any one of claims 1 to 6 is implemented.
