tag:blogger.com,1999:blog-8285843041945560892.post6566262383610752713..comments2023-08-31T16:47:41.588-05:00Comments on for h in hexes:: Trade VII: Why Can't I Find What I'm Looking For?Shelbyhttp://www.blogger.com/profile/01934167527605261647noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-8285843041945560892.post-74599460159459054202023-07-05T20:06:08.674-05:002023-07-05T20:06:08.674-05:00An excellent question, which I'll use as a jum...An excellent question, which I'll use as a jumping-off point for a post, since I've been dark for far too long.Shelbyhttps://www.blogger.com/profile/01934167527605261647noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-86805212513632139782023-06-28T19:48:03.464-05:002023-06-28T19:48:03.464-05:00Been a while, but Alexis' recent post generate...Been a while, but Alexis' recent post generated an interesting comment from you regarding using his Sage system to effect manufacturing and prices. Care to share the direction you're taking. I recently watched his (ten year old) youtube and caught something I missed in the last third regarding references for "service providers." I may try to revisit this approach unless the Sage abilities shows more promise.DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-37306342822459149192023-03-27T18:43:20.776-05:002023-03-27T18:43:20.776-05:00I'm revisiting this as Alexis writes his book....I'm revisiting this as Alexis writes his book. When I originally "created" my sheets I labeled them NTME22 and Mfg22. So now it's time to update. I've kept a list of what resources I want/need to add and Alexis' contribution will probably give me dozens more for this go-round. But I'm also contemplating adding in a calculation for "with or without" local skilled craftsmen. Not sure WHERE I'm headed but it floats through my head and will get a "test add" sometime in the late spring.DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-18430164024286898542022-10-12T01:08:21.750-05:002022-10-12T01:08:21.750-05:00I am reading all this.I am reading all this.Alexis Smolenskhttps://www.blogger.com/profile/10539170107563075967noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-14810949486999758402022-09-22T13:41:59.378-05:002022-09-22T13:41:59.378-05:00At least for this project, the simulation aspects ...At least for this project, the simulation aspects are siloed off, in large part to make this more gameable.<br /><br />That sounds like a pretty good rule of thumb.Shelbyhttps://www.blogger.com/profile/01934167527605261647noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-62176303619120271652022-09-22T11:54:26.477-05:002022-09-22T11:54:26.477-05:00IIRC you're designing more of a "simulati...IIRC you're designing more of a "simulation" than a game-able location, so that might be a difference in our approaches. <br /><br />Population effects infrastructure so it's interrelated. But I generally use 10% of the pop in gp for availability as well as purchasing power (when the party wants to unload some treasure.)DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-84045310876761274782022-09-22T10:21:31.786-05:002022-09-22T10:21:31.786-05:00Presence of a skilled tradesman for a particular r...Presence of a skilled tradesman for a particular raw good makes a lot of sense. Currently, I distribute raw goods, then tradesmen, but a second redistribution step could be very interesting.<br /><br />What's your formula for max price based on population? As I type, seems it could also be affected by infrastructure.Shelbyhttps://www.blogger.com/profile/01934167527605261647noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-79720371085761627552022-09-21T18:51:14.677-05:002022-09-21T18:51:14.677-05:00I stole liberally from you and Alexis of course. ...I stole liberally from you and Alexis of course. Short version? There can BE no short version!<br />1. Wood. Based on biome, elevation and population with a ceiling.<br />2. Ores and minerals. Much of it based on geographic features. Everything else randomized. Nobodt gets more than 1 reference.<br />3. Livestock. formula based on population, infrastructure, biome, elevation and latitude, with a few "personality" twists. ex: Horse production is limited. Mongol-like people however produce a LOT. And they're good!<br />4. Crops. Remember all of that Climate work we did about a year ago? That. And biome, population, infrastructure.<br />5. Stones. Similar to ores and minerals.<br />6. Wildlife. Similar to livestock above.<br /><br />This tells me how much of anything a city produces for resale. If the village doesn't have a skilled tradesman to change a resource into a product, it's shipped out in return for finished goods so it's more expensive because it's bought from a peddler or an outfitter. <br /><br />My spreadsheet has a page for each “shop” with products listed. I've used conditional formatting to “disappear” items over a certain price (based on population of the village) or under a certain level of occurrence for raw materials.<br /><br />You keep askin', I'll keep answerin'. DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-739986886795717712022-09-21T11:21:19.954-05:002022-09-21T11:21:19.954-05:00Very nice! How do you assign the references to the...Very nice! How do you assign the references to the cities and determine if an item is actually available?Shelbyhttps://www.blogger.com/profile/01934167527605261647noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-79215784701384436242022-09-20T10:05:49.867-05:002022-09-20T10:05:49.867-05:00I have! Unlike your effort I'm using a couple...I have! Unlike your effort I'm using a couple linked spreadsheets instead of writing code - since I CAN'T write code and much as I'd LIKE to earn it ain't gonna happen. Sheet 1 is each of the references for each city. No production formulas. Sheet 2 collects the local references (which of course changes from locale to locale,) on the first page with about 40 subsequent sheets which represent/incorporate the recipes and resulting prices. Had a BLAST putting it together and I sleep soundly knowing that wherever my parties go I can give them an accurate price for any item they might wanna purchase. Had a player wanting to buy 50' of silk rope. Never SEEN a mulberry tree! It woulda cost over 3k gp if it existed, which it did NOT in this small 3k population village. <br /><br />The presence of all elements does not necessarily mean the presence of the finished product as folks still need to process it. There's no weaponsmith in most small towns but there may be an outfitter, who charges quite a bit more for transporting the weapon from where it WAS made to the frontier where the party is. DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-60672729412718685782022-09-19T10:01:18.387-05:002022-09-19T10:01:18.387-05:00I think I'm overthinking. GIGO (garbage in, ga...I think I'm overthinking. GIGO (garbage in, garbage out) as they say. If we get a bizarre price for something that ought to be common, it's not always obvious if that is the system working as intended, or if its a bug somewhere in how we've defined things.<br /><br />I've certainly used odd pricing to pick out more than a few bugs in the actual code, or used it to rethink how I assign resources, etc.<br /><br />On the other hand, I might be trying to rush perfection. These oddities might just take years of refinement and beating against the rocks of player expectation.<br /><br />Have you implemented any of the trade process in your setting?Shelbyhttps://www.blogger.com/profile/01934167527605261647noreply@blogger.comtag:blogger.com,1999:blog-8285843041945560892.post-45898624094692272832022-09-17T10:11:36.579-05:002022-09-17T10:11:36.579-05:00glad you're back posting. we've both been...glad you're back posting. we've both been all over Alexis' issues with scarcity. And I've used a few log functions for some of my production as well. Trying to figure out which problem you're trying to solve here: too much production or not enough? Too high a price or too low? Or just overthinking potential outcomes? Would love to join the discussion of how to approach the solution, as I might then incorporate it myself!<br />DM's Escritoirehttps://www.blogger.com/profile/07115399086721890187noreply@blogger.com