Guest User

Untitled

a guest
Apr 26th, 2012
25
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. width_step = (Range("max_w").Value - Range("min_w").Value) / 10
  2. For read_row = 2 To calcline               ' for every optional set, do calculation
  3.    If Worksheets("Calc").Cells(read_row, 1).Value = "" Then Exit For
  4.     cur_width = Range("min_w").Value
  5.     While (cur_width <= Range("max_w").Value)
  6.     'For cur_width = Range("min_w").Value To Range("max_w").Value Step width_step    ' calculate for every width in 1mm steps
  7.        Range("diameter_p").Value = Worksheets("Calc").Cells(read_row, 4).Value
  8.         Range("diameter_g").Value = Worksheets("Calc").Cells(read_row, 5).Value
  9.         Range("module").Value = Worksheets("Calc").Cells(read_row, 3).Value
  10.         Range("width").Value = Round(cur_width, 1)
  11.         Application.Calculate
  12.        
  13.         Worksheets("Result").Cells(write_row, 1).Value = Worksheets("Calc").Cells(read_row, 1).Value
  14.         Worksheets("Result").Cells(write_row, 2).Value = Worksheets("Calc").Cells(read_row, 2).Value
  15.         Worksheets("Result").Cells(write_row, 3).Value = Worksheets("Calc").Cells(read_row, 3).Value
  16.         Worksheets("Result").Cells(write_row, 5).Value = Worksheets("Calc").Cells(read_row, 4).Value
  17.         Worksheets("Result").Cells(write_row, 6).Value = Worksheets("Calc").Cells(read_row, 5).Value
  18.         Worksheets("Result").Cells(write_row, 7).Value = Round(Range("sig_bend_p").Value * 100, 2)  ' take stress data from "Main"
  19.        Worksheets("Result").Cells(write_row, 8).Value = Round(Range("sig_pit_p") * 100, 2)    ' and show as percentage
  20.        Worksheets("Result").Cells(write_row, 9).Value = Round(Range("sig_bend_g") * 100, 2)
  21.         Worksheets("Result").Cells(write_row, 10).Value = Round(Range("sig_pit_g") * 100, 2)
  22.         Worksheets("Result").Cells(write_row, 11).Value = Round(Range("contact_ratio"), 2)   ' write contact ratio
  23.        Worksheets("Result").Cells(write_row, 4).Value = Round(Range("width"), 2)   ' write width
  24.        write_row = write_row + 1
  25.         If ((cur_width + step) > max_w) Then cur_width = max_w Else cur_width = cur_width + step                    ' next width
  26.    'Next cur_width
  27.    Wend
Advertisement
Add Comment
Please, Sign In to add comment