输出齿轮参数计算.xls

齿齿 轮轮 参参 数数 表表 项目代号 齿数Z1 11 1 0 00 00 00 0 模数m1 12 2 0 00 00 00 0 压力角 20 D0 3491 变位系数x0 0 5 50 00 00 0 全齿高h27 000025 0626 齿顶高系数ha 1 0000 分度圆直径d132 0000 基圆直径db124 0394 齿根圆直径df114 0000 齿轮副中心距及其极限偏差a pfa 侧隙j 刀具基准齿形 精度等级GB100095 200110 9 9 GJ 跨测齿数k2 59683 0000 公法线长度及公差Wk EwmsEwmi 测量柱 球 直径dm 量柱 球 测量距及偏差MEmsEmi 齿圈径向跳动公差Fr126 0000 公法线平均长度Wk 94 516994 271694 1909 公法线长跳动公差Fw 齿形公差ff 齿距极限偏差 pfpt 齿向公差F 38 0000 径向间隙系数C 0 2500 齿距极限偏差 pfpt38 0000 齿厚上偏差EssG 6fpt 228 0000 齿厚下偏差EsiJ 10fpt 380 0000 公法线上偏差Ewms 2 24 45 5 2 27 78 80 0 公法线下偏差Ewmi 3 32 26 6 0 05 55 51 1 齿顶圆da168 0000 齿顶削减后da 1 16 64 4 1 12 25 52 2 齿顶高 da d 2 18 0000 削齿后齿顶高 da d 2 16 0626 齿高缩短率 da da da d 0 1076 齿顶缩短量与m的比值 da da 2 m0 1615m 13 6771 Zdk m 810 6377 911 6517 1012 6648 1113 6771 1214 6886 1315 6994 1416 7095 1517 7191 1618 7282 1719 7368 1820 745 1921 7527 2022 7601 2123 7672 2224 7739 2325 7803 2426 7864 2527 7923 2628 798 2729 8034 2830 8086 2931 8136 3032 8184 3133 823 3234 8275 3335 8318 3436 8359 3537 84 3638 8439 3739 8476 3840 8513 3941 8548 4042 8582 4143 8615 4244 8647 4345 8678 4446 8708 4547 8738 4648 8766 4749 8794 4850 8821 4951 8847 5052 8873 5153 8897 5254 8922 5355 8945 5456 8968 5557 8991 5658 9012 5759 9034 5860 9055 5961 9075 6062 9095 Zda m 1012 6648 1113 6771 1214 6886 1315 6994 1416 7095 1517 7191 1618 7282 1719 7368 1820 745 1921 7527 2022 7601 VLOOKUPVLOOKUP See Also Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find The V in VLOOKUP stands for Vertical SyntaxSyntax VLOOKUPVLOOKUP lookup valuelookup value table arraytable array col index numcol index num range lookup Lookup value is the value to be found in the first column of the array Lookup value can be a value a reference or a text string Table array is the table of information in which data is looked up Use a reference to a range or a range name such as Database or List If range lookup is TRUE the values in the first column of table array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise VLOOKUP may not give the correct value If range lookup is FALSE table array does not need to be sorted You can put the values in ascending order by choosing the SortSort command from the DataData menu and selecting AscendingAscending The values in the first column of table array can be text numbers or logical values Uppercase and lowercase text are equivalent Col index num is the column number in table array from which the matching value must be returned A col index num of 1 returns the value in the first column in table array a col index num of 2 returns the value in the second column in table array and so on If col index num is less than 1 VLOOKUP returns the VALUE error value if col index num is greater than the number of columns in table array VLOOKUP returns the REF error value Range lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match is returned In other words if an exact match is not found the next largest value that is less than lookup value is returned If FALSE VLOOKUP will find an exact match If one is not found the error value N A is returned RemarksRemarks If VLOOKUP can t find lookup value and range lookup is TRUE it uses the largest value that is less than or equal to lookup value If lookup value is smaller than the smallest value in the first column of table array VLOOKUP returns the N A error value If VLOOKUP can t find lookup value and range lookup is FALSE VLOOKUP returns the N A value ExampleExample The example may be easier to understand if you copy it to a blank worksheet How 1 Create a blank workbook or worksheet 2 Select the example in the Help topic Do not select the row or column headers Selecting an example from Help 3 Press CTRL C 4 In the worksheet select cell A1 and press CTRL V 5 To switch between viewing the results and viewing the formulas that return the results press CTRL grave accent or on the ToolsTools menu point to FormulaFormula AuditingAuditing and then click FormulaFormula AuditingAuditing ModeMode The example uses values for air at 1 atm pressure A AB BC C 1 1DensityDensity ViscositViscosit y y TemperatTemperat ureure 2 20 4573 55500 3 30 5253 25400 4 40 6162 93300 5 50 6752 75250 6 60 7462 57200 7 70 8352 38150 8 80 9462 17100 9 91 091 9550 10101 291 710 FormulaFormula DescriptDescript ionion Result Result N A Looks up 1 in column A and returns the value from column B in the same row 2 17 N A Looks up 1 in column A and returns the value from column C in the same row 100 N A Looks up 0 746 in column A Because there is no exact match in column A an error is returned N A N A Looks up 0 1 in column A Because 0 1 is less than the smallest value in column A an error is returned N A N A Looks up 2 in column A and returns the value from column B in the same row 1 71 Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find Lookup value is the value to be found in the first column of the array Lookup value can be a value a reference or a text string Table array is the table of information in which data is looked up Use a reference to a range or a range name such as Database or List If range lookup is TRUE the values in the first column of table array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise VLOOKUP may not give the correct value If range lookup is FALSE table array does not need to be sorted You can put the values in ascending order by choosing the SortSort command from the DataData menu and selecting AscendingAscending The values in the first column of table array can be text numbers or logical values Col index num is the column number in table array from which the matching value must be returned A col index num of 1 returns the value in the first column in table array a col index num of 2 returns the value in the second column in table array and so on If col index num is less than 1 VLOOKUP returns the VALUE error value if col index num is greater than the number of columns in table array VLOOKUP returns the REF error value Range lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match is returned In other words if an exact match is not found the next largest value that is less than lookup value is returned If FALSE VLOOKUP will find an exact match If one is not found the error value N A is returned If VLOOKUP can t find lookup value and range lookup is TRUE it uses the largest value that is less than or equal to lookup value If lookup value is smaller than the smallest value in the first column of table array VLOOKUP returns the N A error value If VLOOKUP can t find lookup value and range lookup is FALSE VLOOKUP returns the N A value 2 Select the example in the Help topic Do not select the row or column headers 5 To switch between viewing the results and viewing the formulas that return the results press CTRL grave accent or on the ToolsTools menu point to FormulaFormula AuditingAuditing and then click FormulaFormula AuditingAuditing ModeMode Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find If range lookup is TRUE the values in the first column of table array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise VLOOKUP may not give the correct value If range lookup is FALSE table array does not need to be sorted Col index num is the column number in table array from which the matching value must be returned A col index num of 1 returns the value in the first column in table array a col index num of 2 returns the value in the second column in table array and so on If col index num is less than 1 VLOOKUP returns the VALUE error value if col index num is greater than the number of columns in table array VLOOKUP returns the REF error value Range lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match is returned In other words if an exact match is not found the next largest value that is less than lookup value is returned If FALSE VLOOKUP will find an exact match If one is not found the error value N A is returned 5 To switch between viewing the results and viewing the formulas that return the results press CTRL grave accent or on the ToolsTools menu point to FormulaFormula AuditingAuditing and then click FormulaFormula AuditingAuditing ModeMode Searches for a value in the leftmost column of a table and then returns a value in the same row from a column you specify in the table Use VLOOKUP instead of HLOOKUP when your comparison values are located in a column to the left of the data you want to find If range lookup is TRUE the values in the first column of table array must be placed in ascending order 2 1 0 1 2 A Z FALSE TRUE otherwise VLOOKUP may not give the correct value If range lookup is FALSE table array does not need to be sorted Col index num is the column number in table array from which the matching value must be returned A col index num of 1 returns the value in the first column in table array a col index num of 2 returns the value in the second column in table array and so on If col index num is less than 1 VLOOKUP returns the VALUE error value if col index num is greater than the number of columns in table array VLOOKUP returns the REF error value Range lookup is a logical value that specifies whether you want VLOOKUP to find an exact match or an approximate match If TRUE or omitted an approximate match is returned In other words if an exact match is not found the next largest value that is less than lookup value is returned If FALSE VLOOKUP will find an exact match If one is not found the error value N A is returned Col index num is the column number in table array from which the matching value mus