tag:blogger.com,1999:blog-3871409676946408069.post5869149221273945925..comments2023-10-14T03:58:59.333-06:00Comments on The Tao of D&D: Making a Distance TableAlexis Smolenskhttp://www.blogger.com/profile/10539170107563075967noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-3871409676946408069.post-66411164330447661862021-09-01T10:56:22.266-06:002021-09-01T10:56:22.266-06:00The only number that counts is the one in the D-co...The only number that counts is the one in the D-column. Once you've set your maximum iterations to 1, each time you manually calculate all the numbers will change ... until all the circular (and inconsistent) calculations sort themselves out. The numbers will look wonky until this happens.Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-7485117897615816792021-09-01T10:41:26.095-06:002021-09-01T10:41:26.095-06:00Managed to recreate the sheet presented here but I...Managed to recreate the sheet presented here but I’m afraid I don’t understand what I’m looking at. Marazibol -Adeese connection is 16? But it was clearly 8 when we started. So what does the 16 represent? I’m sure I’m missing something simple here but the logic of this step is just evading me and I’m tired of sitting her like a dolt so I’ll just ASK!DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-21716068781216739962017-05-18T22:39:49.622-06:002017-05-18T22:39:49.622-06:00Thank you so much! You have answered all my questi...Thank you so much! You have answered all my questions, though I am sure I will find more as I dig through the files over the next while. It feels like world-discovery Christmas. The work you have put in to the trade system is evident, and I appreciate all you have done to make it accessible to others.Samuel Kernanhttps://www.blogger.com/profile/17745996634604734121noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-78082417035760149352017-05-18T22:28:37.735-06:002017-05-18T22:28:37.735-06:00As regards the limits of not connective every port...As regards the limits of not connective every port in the world to every other port . . .<br /><br />I did have one port that did not fit the system. It is a place called Anauroch, in the Andaman Islands east of India. There were places that could import from there, but Anauroch could not import from anywhere (it has 1 market point and is about 40 hexes from another port).<br /><br />Most of the time, when this happens, the port is part of the mainland, so it can be attached to the market system by land, if not by sea. But Anauroch is on an island. But it has to be attached, so . . . I simply designated the nearest port as its one connection and moved on. Sometimes, we have to break a "rule."<br /><br />I expect to start having more trouble with my system when I start mapping the New World (many European ports won't reach across the Atlantic) or Oceania (where the ports, all non-human, will be too small to import anything from anyone). In such a case, I'll make the same Anauroch fix or, in the case of some European colonies, I'll connect them to the nearest Portuguese, French, English or Dutch port.<br /><br />Anything else?<br /><br /><br /><br />Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-23115760589333570772017-05-18T22:24:23.454-06:002017-05-18T22:24:23.454-06:00Samuel,
Thank you for the donation. Much appreci...Samuel,<br /><br />Thank you for the donation. Much appreciated, believe me. I'll try to make it worth your while; I've sent you an email that should let you view the trade content on my google drive.<br /><br />On that, you'll find one small file called "Distances 5oct14" ~ this is the calculation I have excel do for me for "days" between one hex and another. You'll see three columns in yellow. All three are the same, they're just set up that way so I can compare one route to another to see which is shorter.<br /><br />By putting a string of elevations in excel, the file quickly calculates the distance. Each 40 change in elevation between hexes increases the number of days by 0.1.<br /><br />On the right, you'll see two groups of columns in blue. One calculates "down" river and the other "up" river. The numbers are put in the same order for both directions (there's some gobbledygook in the M column, it is just old work that I didn't delete. If you know excel, you'll see quickly why it doesn't matter.<br /><br />The river will then give two different numbers of days; it isn't based at all on the size of the river, though small rivers are very rarely navigable (unless the land is very flat). So if goods are hauled up river, use the larger number, if they are hauled down river, the smaller number.<br /><br />On top of the calculation, I then add small penalties for rivers crossed (0.01 per point of river) and borders (.1 for a state border, .2 for a national border). The number is added each time the route crosses a river or a border, even if it is the same river or border.<br /><br />You can see, then, that I calculate it out one hex at a time. This should pretty much answer your first and second questions.<br /><br />And you found the post for the sea routes. Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-19271515245236258752017-05-18T21:04:41.365-06:002017-05-18T21:04:41.365-06:00Just found this
http://tao-dnd.blogspot.ca/2014/09...Just found this<br />http://tao-dnd.blogspot.ca/2014/09/ship-routes-mediterranean.html<br />which answers how you decide which ports link to each other.Samuel Kernanhttps://www.blogger.com/profile/17745996634604734121noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-16658840175774187332017-05-18T20:34:11.293-06:002017-05-18T20:34:11.293-06:00I have a bunch of questions about your particular ...I have a bunch of questions about your particular methods for measuring days of travel between two places. Thanks in advance if you have time to answer them.<br /><br />When you add additional days of travel time based on elevation difference, do you calculate that looking at one pair of hexes at a time, or based on the overall difference in elevation between start and end points?<br /><br />How do you calculate days of travel when two places are connected by a river? I know you take current into account, is that based on the river size numbers that you put on your maps?<br /><br />Similarly, how many hexes per day do you use for sea routes? And how do you decide what the limits are in terms of not connecting every port in the world to every other port?Samuel Kernanhttps://www.blogger.com/profile/17745996634604734121noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-91576255220998136782016-04-10T12:33:06.755-06:002016-04-10T12:33:06.755-06:00I don't know LibreOffice Calc, but there may a...I don't know LibreOffice Calc, but there may also be a button somewhere else for enabling iterations.<br /><br />I found this, but I don't understand it:<br /><br />http://comments.gmane.org/gmane.comp.documentfoundation.libreoffice.user/25151Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-61991577375738420992016-04-10T12:18:00.330-06:002016-04-10T12:18:00.330-06:00Anyone using LibreOffice Calc for this? I am curre...Anyone using LibreOffice Calc for this? I am currently and I found the iterations option and have it set to 1, but it's still giving me an error.J. Cormierhttps://www.blogger.com/profile/06775658681126093604noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-23848488123441448452016-04-09T21:19:33.856-06:002016-04-09T21:19:33.856-06:00Hm. That's pretty wonderful. Re-invented from ...Hm. That's pretty wonderful. Re-invented from scratch, as I can't ever recall having seen this content before.Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-3871409676946408069.post-16972242508951398302016-04-09T21:01:26.799-06:002016-04-09T21:01:26.799-06:00This is a pretty easy-to-use implementation of Dij...This is a pretty easy-to-use implementation of <a href="https://en.wikipedia.org/wiki/Dijkstra%27s_algorithm" rel="nofollow">Dijkstra's algorithm</a>! You've made me curious to investigate whether there exists possibly faster or more efficient ways of performing these calculations, but the bottleneck may of course be Excel's weaknesses.Timhttps://www.blogger.com/profile/03496502173819113887noreply@blogger.com