Spreadsheet: 88732d1288600155-conditional-output-auto-staircase-drafter99999
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Tread script
 |  |  | [NAME] |  | Input
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Output
 |  |  | Species |  | Spotted Gum
 |  |  | Rise |  | 180 |  |  |  |  |  |  |  | 1 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 1
 |  |  | Run |  | 300 |  |  |  |  |  |  |  | 2 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 2
 |  |  | [NAME] |  | 900 |  |  |  |  |  |  |  | 3 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 3
 |  |  | Number of Treads |  | 1 |  |  |  |  |  |  |  | 4 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 4
 |  |  | Tread Thickness |  | 35 |  |  |  |  |  |  |  | 5 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 5
 |  |  | Tread Overhang |  | 25 |  |  |  |  |  |  |  | 6 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 6
 |  |  | Riser Thickness |  | 18 |  |  |  |  |  |  |  | 7 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 12
 |  | Calculated |  |  |  |  | Tread and risers |  |  |  |  |  | 13 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  | 14 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 14
 |  | rise run angle |  |  |  |  | cut tread width |  |  |  |  |  | 15 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 15
 |  | true tread to tread angle |  |  |  |  | cut tread length |  |  |  |  |  | 16 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 16
 |  | true tread to tread run |  |  |  |  | cut riser length |  |  |  |  |  | 17 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 17
 |  | true tread to tread hypotenuse |  |  |  |  | cut riser height |  |  |  |  |  | 18 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 18
 |  | riser height |  |  |  |  |  |  |  |  |  |  | 19 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | [NAME] |  |  |  |  |  | 20 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 20
 |  | inner rise |  |  |  |  | ^atan2 of inner run to true [NAME] |  |  |  |  |  | 21 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 21
 |  | inner run |  |  |  |  | array column offset (tread+riser) |  |  |  |  |  | 22 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 22
 |  | inner angle |  |  |  |  | ^hyp of inner run to true [NAME] |  |  |  |  |  | 23 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 23
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 24 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  | 25 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  | 26 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  | 27 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 27
 |  |  |  |  |  |  |  |  |  |  |  |  | 28 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  | 29 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 29
 |  |  |  |  |  |  |  |  |  |  |  |  | 30 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  | 31 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 32 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  | 33 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  |  |  |  | 34 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  | 35 | rectangle |  |  | , |  |  |  |  |  |  | , |  |  |  |  |  |  | 35
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 | displacement x |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 | displacement y |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Top Tread Width |  | 75 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer [NAME] |  | 240 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer Thickness |  | 50 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer Mortise |  | 12 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer O/hang Lower Rise |  | 100 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer O/hang Top Tread |  | 50 |  |  |  |  | < |  |  |  |  |  |  |  | <
 | Stringer Hook Length |  | 50 |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <
 |  |  |  |  |  |  |  | < |  |  |  |  |  |  |  | <