Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Excel method for randomizing object pitch/roll:
- 1. Export from TB with custom format with comma separator, nothing else changed
- 2. Open in excel, select "Delimited" box and click next
- 3. In the "Delimiters" box, uncheck everything except "Comma"
- 4. On this same window, set the "Text qualifier" drop down menu to "{none}" and click next
- 5. Click finish - Import should be successful
- 6. Select column E cells with data (Ctrl-Shift-DOWN Arrow) and enter the expression =x+y*RAND() where x = minimum number, and y equals the range above that.
- If you want the max pitch to be 5.0 and the min pitch to be -5.0 (same as 355, still works on TB import), the expression
- should look like this: =-5+10*RAND()
- Ctrl-ENTER executes formula on all selected cells
- 7. Do the same to column F to randomize the object's roll as well
- 8. When ready to export, click File -> Save As, and select .csv (Comma Delimited) as the export format.
- 9. Enter a new name, save, and open in NPP.
- 10. Find and Replace -> [,] with [;]
- 11. Find and Replace -> ["""] with ["]
- 12. Save and import into TB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement