This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Lots of multi-row tools... - Worked out and normalised the facing angle (so 0 for East, 90 for South, etc...) - Tracked X and Y separately as easiest - For WP should have treated as spatial but kept as string instead
It's seriously ugly (10 multi-row formula tools, a nested IF with 20 conditions and an iterative macro for good measure) but at least it runs in 3 seconds which is an improvement on the 2 hours from yesterday!
refactoring the instructions to turn "W" into "E", "S" into "N", "L" into "R" made the multi-rows easier to handle.
They'd also look a lot neater in a language with implicit type conversion, there are ToString() and ToNumber(GetWord()) functions everywhere.
Edit: Oh I could definitely smush the two multi-rows in part 2 into 1 multi-row as they're both of the same Switch([instr],...) function and use a coord format "wx wy bx by dir dist" but I'll leave that as an exercise to the reader.