A method and system for establishing a comfortable cross-sectional belt model for a car seat

Abstract

The present invention relates to a method and system for establishing a comfortable section belt model of an automobile seat, the method comprising the following steps: reading a sheet specified in an Excel table at a specified position, and defining the cells represented by the first row and the first column; reading the coordinates of a reference point at a comfort key surface and the relative coordinates of each item at the comfort key surface; calculating the distance from each relative coordinate to the reference point; comparing all distances calculated in S03 to obtain the maximum and minimum values ​​of the distance; reading a sheet specified in an Excel table at a specified position, and writing and saving the distance and the maximum and minimum values ​​in a specified position in the Excel table; and connecting the corresponding relative coordinates of the maximum and minimum values ​​respectively. After establishing the model according to the method provided by the present invention, directly importing the corresponding section of the new project seat shape CAS into the model, the difference point can be obtained.

Description

Technical Field

[0001] The invention relates to the technical field of automobile seat design, and in particular to a technology for establishing a comfortable section belt model of an automobile seat. Background Art

[0002] As people's living standards continue to improve, users' demand for cars is not just a means of transportation. More and more users are paying great attention to the comfort of car seats. The R&D departments of major OEMs have also invested a lot of time and energy in seat comfort design to develop comfortable seats that meet user needs as much as possible.

[0003] The indicator that has the greatest impact on seat comfort is the key comfort section of the seat. The traditional comfort section analysis method is: the styling designer designs the seat CAS according to his own creativity, the product engineer manually scans the reverse comfort target model seat point cloud and uses CATIA to process it to obtain the target model seat comfort section, and then relies on manual comparison of the key comfort section of the styling CAS and the target model seat comfort section, and then proposes an optimization plan. This seat comfort key section analysis method has the following disadvantages: First, each new project needs to scan the reverse comfort target model seat, and then perform manual measurement and comparison, which is time-consuming and inefficient; second, the single comparison of the comfort target model seat section, due to the differences in the seat frame platform, foam formula, etc. with the target model, the optimization plan formulated in this way has low accuracy and is difficult to meet the needs of different customers on the market for seat comfort.

[0004] Faced with increasingly fierce market competition, how to quickly and accurately specify a comfortable seat design that meets the needs of the vast majority of users in the market and improve the efficiency of analyzing and optimizing key sections of seat comfort has become an urgent problem that seat product development engineers of various automobile OEMs need to solve. Summary of the invention

[0005] The purpose of the present invention is to provide a method and system for establishing a car seat comfort section belt model, and to solve the technical problem that the existing reverse analysis method of the key section of seat comfort is low in efficiency and poor in accuracy.

[0006] In order to solve the above technical problems, the technical solution adopted by the present invention is: a method for establishing a comfortable cross-sectional belt model of a car seat, comprising the following steps:

[0007] S01: reading a specified sheet in an Excel table at a specified position, and defining cells represented by the first row and the first column, wherein the Excel table stores relative coordinates of intersections between Y0 sections and each comfort key surface of a plurality of vehicle comfort seats with similar arrangement conditions;

[0008] S02: reading the coordinates of the reference point at the comfort key surface and the relative coordinates of each item at the comfort key surface;

[0009] S03: Calculate the distance from each relative coordinate to the reference point;

[0010] S04: comparing all the distances calculated in S03 to obtain the maximum and minimum values ​​of the distances;

[0011] S05: Reading a sheet specified in the Excel table at the specified position, writing and saving the distance in S03 and the maximum and minimum values ​​in S04 into the specified position in the Excel table;

[0012] S06: Connect the corresponding relative coordinates of the maximum value and the minimum value in S05 respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

[0013] Preferably,

[0014] In the S01, the Y0 sections of the backrests of several typical comfort driver's seats are collected, the seat design R point and the coordinate origin are overlapped, and the relative coordinates of at least six key points on the Y0 section of the backrest described in each project are collected, and the six key points are: the departure point on the backrest, the intersection of the H+450 plane of the backrest and the Y0 section, the intersection of the H+350 plane of the backrest and the Y0 section, the intersection of the H+145 plane of the backrest and the Y0 section, the intersection of the H+35 plane of the backrest and the Y0 section, and the departure point below the backrest.

[0015] Preferably,

[0016] The CATIA secondary development tool GSD_PointSplineLoftFromExcel is used to execute the task in S06.

[0017] Preferably,

[0018] In the S01, starting from 0 is recorded as the first row;

[0019] Starting from 0, it is recorded as the first column.

[0020] Preferably,

[0021] In S03, the distance from each relative coordinate to the reference point is calculated using the Pythagorean theorem formula.

[0022] The present invention also provides a system for establishing a comfortable cross-sectional belt model of an automobile seat, comprising:

[0023] A first reading module is used to read a specified sheet in an Excel table at a specified position and define cells represented by a first row and a first column, wherein the Excel table stores relative coordinates of intersections of Y0 sections and each comfort key surface of a plurality of molded comfort seats with similar arrangement conditions collected;

[0024] A second reading module is used to read the coordinates of the reference point at the comfort key surface and the relative coordinates of each item at the comfort key surface;

[0025] A calculation module, used for calculating the distance from each relative coordinate to a reference point;

[0026] A comparison module, used for comparing all the distances calculated in the calculation module to obtain the maximum and minimum values ​​of the distances;

[0027] A third reading module is used to read the sheet specified in the Excel table at the specified position again;

[0028] A writing module, used for writing the distance in the calculation module and the maximum value and the minimum value in the comparison module into a specified position in an Excel table;

[0029] A saving module, used for saving the distance, maximum value and minimum value written by the writing module in a specified position in the Excel table;

[0030] The connection module is used to connect the corresponding relative coordinates of the maximum value and the minimum value in the storage module respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

[0031] Preferably,

[0032] In the first reading module, the Y0 sections of the backrests of several typical comfort driver's seats are collected, the seat design R point and the coordinate origin are overlapped, and the relative coordinates of at least six key points on the Y0 section of the backrest described in each project are collected. The six key points are: the departure point on the backrest, the intersection of the H+450 plane of the backrest and the Y0 section, the intersection of the H+350 plane of the backrest and the Y0 section, the intersection of the H+145 plane of the backrest and the Y0 section, the intersection of the H+35 plane of the backrest and the Y0 section, and the departure point below the backrest.

[0033] Preferably,

[0034] The CATIA secondary development tool GSD_PointSplineLoftFromExcel is used to execute the connection task in the connection module.

[0035] Preferably,

[0036] In the first reading module, starting from 0 is recorded as the first row;

[0037] Starting from 0, it is recorded as the first column.

[0038] Preferably,

[0039] In the calculation module, the distance from each relative coordinate to the reference point is calculated using the Pythagorean theorem formula.

[0040] By adopting the above technical scheme, the beneficial technical effect that can be achieved by the present invention is as follows: after the automobile seat comfort section belt model is established by the method provided by the present invention, the corresponding section of the new project seat shape CAS is directly imported into the model, and the difference points can be clearly obtained and the optimization scheme can be determined without reverse comparison of data; if new seat comfort parameters are added later, the corresponding relative coordinates of the maximum and minimum values ​​at each comfort key surface can be re-identified after fine-tuning the program, and a new automobile seat comfort section belt model can be obtained by re-importing it into CATIA, thereby effectively ensuring the novelty and applicability of the model. BRIEF DESCRIPTION OF THE DRAWINGS

[0041] Figure 1 Establish a flow chart for the comfort section belt model of the car seat;

[0042] Figure 2 Write a flowchart for a python program. DETAILED DESCRIPTION

[0043] The present invention will be further described below in conjunction with the accompanying drawings.

[0044] like Figure 1 As shown, the present invention provides a method for establishing a comfortable cross-sectional belt model of a car seat. To further illustrate the method, an embodiment is provided below.

[0045] In this embodiment, a Y0 section belt model of the comfort backrest of a car seat is established by python.

[0046] First, you need to collect the Y0 sections of the backrests of five typical comfort driver seats, overlap the seat design R point with the coordinate origin, and collect the relative coordinates of six key points on the Y0 section of the backrest of each project. The six key points are the departure point on the backrest, the intersection of the H+450 plane of the backrest and the Y0 section, the intersection of the H+350 plane of the backrest and the Y0 section, the intersection of the H+145 plane of the backrest and the Y0 section, the intersection of the H+35 plane of the backrest and the Y0 section, and the departure point under the backrest.

[0047] like Figure 1 and Figure 2As shown, the present invention provides a method for establishing a comfortable section belt model of a car seat, the method comprising the following steps:

[0048] S01: Read a sheet specified in an EXCEL table at a specified position, and define cells represented by the first row and the first column, wherein the Excel table stores relative coordinates of intersection points of Y0 sections and each comfort key surface of multiple vehicle comfort seats with similar arrangements.

[0049] Specifically,

[0050] import xlrd

[0051] ExcelFile = xlrd.open_workbook ("E:\Room Group Work\Seat Capacity Building\Seat Comfort\Python\Seat Comfort Model Parameter Library-Y0 Section.xlsx") # Read Excel file location

[0052] table = ExcelFile.sheet_by_name ("Backrest Section Python Implementation") # Read the specified table

[0053] rowl=table.row_values(0)#Start from 0 and record it as the first row

[0054] coll=table.col_values(0)#Start from 0 and record it as the first column

[0055] S02: Read the coordinates of the reference point at the comfort critical surface and the relative coordinates of each item at the comfort critical surface.

[0056] Specifically,

[0057] a1=table.cell_value(2,2)#Define the X coordinate position of reference point 1 in the Excel table

[0058] b1=table.cell_value(2,3)#Define the Z coordinate position of reference point 1 in the Excel table

[0059] print("Coordinates of reference point 1:", a1, b1)

[0060] V301S_X1=table.cell_value(2,4)

[0061] V301S_Z1= table.cell_value(2,5)

[0062] print("Relative coordinates of the departure point on the backrest of V301Skao:", V301S_X1, V301S_Z1)

[0063] S03: Calculate the distance from each relative coordinate to the reference point.

[0064] Specifically,

[0065] import math

[0066] #Calculate the distance from the departure point on the backrest of each item to the reference point 1

[0067] V301S_L1=math.sqrt((V301S_X1-a1)**2+(V301S_Z1-b1)**2)

[0068] print("V301S_L1=",V301S_L1)

[0069] S04: Compare all distances calculated in S03 to obtain the maximum and minimum distances.

[0070] Specifically,

[0071] #Calculate the minimum and maximum distances from the departure point on the backrest to the reference point 1 for each item

[0072] listt1=[V301S_L1,F201_L1,F202_L1,B316_L1,UNIK_L1]

[0073] print("The minimum value of L1 is:",min(listt1))

[0074] print("The maximum value of L1 is:",max(listt1),"\n")

[0075] S05; read the specified sheet in the Excel table at the specified position, write and save the distance in S03 and the maximum value and the minimum value in S04 to the specified position in the Excel table.

[0076] Specifically,

[0077] # Write the calculation results into Excel table

[0078] import openpyxl

[0079] workbook = openpyxl.load_workbook ("E:\Room Group Work\Seat Capacity Building\Seat Comfort\Python\Seat Comfort Model Parameter Library - Y0 Section.xlsx")

[0080] worksheet = workbook["Backrest Section Python Implementation"]

[0081] worksheet["G3"]=V301S_L1

[0082] worksheet["J3"]=F201_L1

[0083] worksheet["M3"]=F202_L1

[0084] worksheet["P3"]=B316_L1

[0085] worksheet["S3"]=UNIK_L1

[0086] worksheet["T3"]=min(listt1)

[0087] worksheet["U3"]=max(listt1)

[0088] workbook.save("E:\Room Group Work\Seat Capacity Building\Seat Comfort\Python\Seat Comfort Model Parameter Library - Y0 Section.xlsx")

[0089] S06: Connect the corresponding relative coordinates of the maximum value and the minimum value in S05 respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section and the Y0 section belt model of the car seat comfort.

[0090] Specifically, the corresponding response coordinates of the maximum and minimum values ​​at each comfort key surface are sorted out, and the corresponding relative coordinates of the maximum and minimum values ​​are imported and connected using the CATIA secondary development tool GSD_PointSplineLoftFromExcel. In this way, two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value can be obtained. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

[0091] After the car seat comfort section belt model is established, the corresponding section of the new project seat shape CAS can be directly imported into the model. Without the need for reverse data comparison, the differences can be clearly identified and the optimization plan can be determined.

[0092] If new seat comfort parameters are added in the future, the relative coordinates corresponding to the maximum and minimum values ​​at each comfort key surface can be re-identified by fine-tuning the Python programming program, and then re-imported into CATIA to obtain a new car seat comfort section belt model, ensuring the novelty and applicability of the model.

[0093] The present invention also provides a system for establishing a comfortable cross-sectional belt model of a car seat, comprising:

[0094] A first reading module is used to read a specified sheet in an Excel table at a specified position and define cells represented by the first row and the first column, wherein the Excel table stores relative coordinates of intersections of Y0 sections and each comfort key surface of a plurality of molded comfort seats with similar arrangement conditions collected;

[0095] The second reading module is used to read the coordinates of the reference point at the comfort key surface and the relative coordinates of each item at the comfort key surface;

[0096] A calculation module, used to calculate the distance from each relative coordinate to a reference point;

[0097] The comparison module is used to compare all distances calculated in the calculation module to obtain the maximum and minimum values ​​of the distances;

[0098] The third reading module is used to read the specified sheet in the Excel table at the specified position again;

[0099] A writing module, used for writing the distance in the calculation module and the maximum value and the minimum value in the comparison module into a specified position in the Excel table;

[0100] A saving module, used for saving the distance, maximum value and minimum value written by the writing module in a specified position in an Excel table;

[0101] The connection module is used to connect the corresponding relative coordinates of the maximum value and the minimum value in the storage module respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

[0102] Specifically,

[0103] In the first reading module, the Y0 sections of the backrests of five typical comfort driver seats are collected, the seat design R point and the coordinate origin are overlapped, and the relative coordinates of six key points on the Y0 section of the backrest of each project are collected. The six key points are: the departure point on the backrest, the intersection of the H+450 plane of the backrest and the Y0 section, the intersection of the H+350 plane of the backrest and the Y0 section, the intersection of the H+145 plane of the backrest and the Y0 section, the intersection of the H+35 plane of the backrest and the Y0 section, and the departure point on the bottom of the backrest.

[0104] Specifically,

[0105] CATIA secondary development tool GSD_PointSplineLoftFromExcel performs the wiring task in the wiring module.

[0106] Specifically,

[0107] In the first reading module, it is recorded as the first row starting from 0;

[0108] Starting from 0, it is recorded as the first column.

[0109] Specifically,

[0110] In the calculation module, the distance from each relative coordinate to the reference point is calculated using the Pythagorean theorem formula.

Claims

1. A method for establishing a comfortable cross-sectional belt model for a car seat, characterized in that: The following steps are involved: S01: Read the sheet specified in the Excel table at the specified position, and define the cells represented by the first row and the first column, wherein the Excel table stores the relative coordinates of the Y0 sections of the collected comfort seats of multiple models with similar arrangements and the intersection points of each comfort key surface, specifically, collect the Y0 sections of the backrests of several typical comfort main driver seats, overlap the seat design R point with the coordinate origin, and collect the relative coordinates of at least six key points on the Y0 section of the backrest of each project, the six key points are: the departure point on the backrest, the intersection point of the backrest H+450 plane and the Y0 section, the intersection point of the backrest H+350 plane and the Y0 section, the intersection point of the backrest H+145 plane and the Y0 section, the intersection point of the backrest H+35 plane and the Y0 section, and the departure point on the backrest; S02: reading the coordinates of the reference point at the comfort key surface and the relative coordinates of each item at the comfort key surface; S03: Calculate the distance from each relative coordinate to the reference point; S04: comparing all the distances calculated in S03 to obtain the maximum and minimum values ​​of the distances; S05: Reading a sheet specified in the Excel table at the specified position, writing and saving the distance in S03 and the maximum and minimum values ​​in S04 into the specified position in the Excel table; S06: Connect the corresponding relative coordinates of the maximum value and the minimum value in S05 respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

2. The method for establishing a comfortable cross-sectional belt model of a car seat according to claim 1, characterized in that: The CATIA secondary development tool GSD_PointSplineLoftFromExcel is used to execute the task in S06.

3. The method for establishing a comfortable cross-sectional belt model of a car seat according to claim 1, characterized in that: In the S01, the first row is recorded starting from 0; the first column is recorded starting from 0.

4. The method for establishing a comfortable cross-sectional belt model of a car seat according to claim 1, characterized in that: In S03, the distance from each relative coordinate to the reference point is calculated using the Pythagorean theorem formula.

5. A system for establishing a comfortable cross-sectional belt model for a car seat, characterized in that: include: A first reading module is used to read a sheet specified in an Excel table at a specified position, and define cells represented by the first row and the first column, wherein the Excel table stores the relative coordinates of the Y0 sections of a plurality of collected molded comfort seats with similar arrangements and the intersection points of each comfort key surface, specifically, collecting the Y0 sections of the backrests of a number of typical comfort main driver seats, aligning the seat design R point with the coordinate origin, and collecting the relative coordinates of at least six key points on the Y0 section of the backrest of each project, wherein the six key points are: an upper departure point of the backrest, an intersection point of the backrest H+450 plane and the Y0 section, an intersection point of the backrest H+350 plane and the Y0 section, an intersection point of the backrest H+145 plane and the Y0 section, an intersection point of the backrest H+35 plane and the Y0 section, and a lower departure point of the backrest; A second reading module is used to read the coordinates of the reference point at the comfort key surface and the relative coordinates of each item at the comfort key surface; A calculation module, used for calculating the distance from each relative coordinate to a reference point; A comparison module, used for comparing all the distances calculated in the calculation module to obtain the maximum and minimum values ​​of the distances; A third reading module is used to read the sheet specified in the Excel table at the specified position again; A writing module, used for writing the distance in the calculation module and the maximum value and the minimum value in the comparison module into a specified position in an Excel table; A saving module, used for saving the distance, maximum value and minimum value written by the writing module in a specified position in the Excel table; The connection module is used to connect the corresponding relative coordinates of the maximum value and the minimum value in the storage module respectively to obtain two curves corresponding to the corresponding relative coordinates of the maximum value and the corresponding relative coordinates of the minimum value. The two curves form the interval of the Y0 section, that is, the Y0 section belt model of automobile seat comfort.

6. The system for establishing a comfortable cross-sectional belt model of a car seat according to claim 5, characterized in that: The CATIA secondary development tool GSD_PointSplineLoftFromExcel is used to execute the connection task in the connection module.

7. The system for establishing a comfortable cross-sectional belt model of a vehicle seat according to claim 5, characterized in that: In the first reading module, starting from 0 is recorded as the first row; Starting from 0, it is recorded as the first column.

8. The system for establishing a comfortable cross-sectional belt model of a vehicle seat according to claim 5, characterized in that: In the calculation module, the distance from each relative coordinate to the reference point is calculated using the Pythagorean theorem formula.

Images