Advertisement
BobTheHunted

Randomize Object Pitch/Roll for A3 Terrains

Feb 2nd, 2018
301
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. Excel method for randomizing object pitch/roll:
  2.  
  3. 1. Export from TB with custom format with comma separator, nothing else changed
  4. 2. Open in excel, select "Delimited" box and click next
  5. 3. In the "Delimiters" box, uncheck everything except "Comma"
  6. 4. On this same window, set the "Text qualifier" drop down menu to "{none}" and click next
  7. 5. Click finish - Import should be successful
  8. 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.
  9. 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
  10. should look like this: =-5+10*RAND()
  11. Ctrl-ENTER executes formula on all selected cells
  12. 7. Do the same to column F to randomize the object's roll as well
  13. 8. When ready to export, click File -> Save As, and select .csv (Comma Delimited) as the export format.
  14. 9. Enter a new name, save, and open in NPP.
  15. 10. Find and Replace -> [,] with [;]
  16. 11. Find and Replace -> ["""] with ["]
  17. 12. Save and import into TB
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement