Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account

Specific Macro Help!

1602300302

Edited 1602300701
Hello! I want to create a Macro for travel times that will display a result in Hours and Days So far I have this: ?{Distance (Miles)} miles in [[?{Distance (Miles)}/?{Form of Transport?|Walking Easy Terrain,3]] hours walking on Easy Terrain|Walking Moderate Terrain,2]] hours walking on Moderate Terrain|Walking Rough Terrain,1]] hours walking on Rough Terrain|Jogging Easy Terrain,5]] hours jogging on Easy Terrain|Jogging Moderate Terrain,4]] hours jogging on Moderate Terrain|Running Easy Terrain,6]] hours Running on Easy Terrain|Horseback Walk Easy Terrain,4]] hours by horseback walking on Easy Terrain|Horseback Walk Moderate Terrain,3]] hours by horseback walking on Moderate Terrain|Horseback Trot Easy Terrain,8]] hours by horseback at a trot on Easy Terrain|Horseback Trot Moderate Terrain,2]] hours by horseback at a trot on Moderate Terrain|Horseback Gallop Easy Terrain,9]] hours by horseback at a gallop on Easy Terrain} Now I want to take the result of whatever is shown and divide the hour amount by 10 hour travel days or I suppose, more accurately to add the division for specific travel days based on hours able to maintain a specific pace into it. So to input the distance - then the form of travel, and have the macro take into account how long youd be able to travel at that pace (e.g. Running, 4 hours, Walking 10 hours) and display the result in hours and travel days. Any help would be wonderful!
1602310264

Edited 1602310467
Oosh
Sheet Author
API Scripter
Something like this? &{template:default} {{name=Travel Calculator}} [[ ceil([[?{Distance in Miles|100}/?{Form of Transport| Walking Easy Terrain,3]]/?{Hours traveled per day|10}) ]] {{Walking on Easy Terrain| Walking Moderate Terrain,2]]/?{Hours traveled per day|10}) ]] {{Walking on Moderate Terrain| Walking Rough Terrain,1]]/?{Hours traveled per day|10}) ]] {{Walking on Rough Terrain| Jogging Easy Terrain,5]]/?{Hours traveled per day|10}) ]] {{Jogging on Easy Terrain| Jogging Moderate Terrain,4]]/?{Hours traveled per day|10}) ]] {{Jogging on Moderate Terrain| Running Easy Terrain,6]]/?{Hours traveled per day|10}) ]] {{Running on Easy Terrain| Horseback Walk Easy Terrain,4]]/?{Hours traveled per day|10}) ]] {{Walk on Horseback, Easy Terrain| Horseback Walk Moderate Terrain,3]]/?{Hours traveled per day|10}) ]] {{Walk on Horseback, Moderate Terrain| Horseback Trot Easy Terrain,8]]/?{Hours traveled per day|10}) ]] {{Trot on Horseback, Easy Terrain| Horseback Trot Moderate Terrain,2]]/?{Hours traveled per day|10}) ]] {{Trot on Horseback, Moderate Terrain| Horseback Gallop Easy Terrain,9]]/?{Hours traveled per day|10}) ]] {{Gallop on Horseback, Easy Terrain}=$[[1]] days' travel}} {{?{Distance in Miles} mile journey=$[[0]] hours' travel at ?{Hours traveled per day} per day}} I didn't proof it too carefully, I might have bungled the hours taken per travel option or something. See what you think, can be changed around or switched to another template if you don't like it. There's some nasty HTML entities in the middle there because of the nested Query, but that's the price you pay for having the text and calculable value in the same Query response :) edit - Oh, I have the days rounded up as well. Change "ceil" to "round" if you just want normal rounding (i.e. currently 2.3 days will output "3 days' travel", if you change it to "round" it would give "2 days' travel").