Leaderboard

Well, I've basically conducted enough tests to convince me I've got the orthodox supply and demand model mostly figured out. I've attached the excel sheets containing the values for the 1.57 fan patched executable. I'm about 50-60% done my toy DB app for planning train routes now. Roughly speaking, the demand numbers for each industrial building are listed in the float called demand in jeffryfisher's extraction of the executable. However, pouring 4 units of coal and 4 units of iron into a steel mill doesn't result in a long term equilibrium demand level of 5. It's actually closer to a long term equilibrium of 2 or so. Getting any industry to an equilibrium demand level of 5 requires you to deliver about half of its demand requirements. Since 70% the revenue on twice the volume still nets 140% of the revenue you get keeping the price at 100%, and since you probably use fewer trains to do it and get to buy a steel mill gushing cash on top of everything else, you'd be kind of a fool to shoot for maintaining level 5 demand. Multiple industries don't stack demand proportionately, but multiple houses DO. There are a lot of cases where the demand and supply numbers don't quite line up. 2 1/2 bauxite mines sate 1 aluminum mill which sates 1 2/3rds Tool and Die Factories, for example. I've classified industrial buildings into 3 types. Single, Combination and Parallel. Single input buildings are places with one input and one output, like aluminum mills and fertilizer factories. Combination input buildings are 2 things in, one thing out, like steel mills. Parallel have two inputs that aren't combined, like a textile mill. There are also parallel pairings, such as the weapons and munitions factories and the cannery, especially between 1910 and 1930. Outstanding questions: Do buildings with parallel pairing inputs experience extra demand for one half of a pair if the second half is unavailable in the scenario? Example. Canneries have 3 demand for produce and 3 demand for steel or aluminum in the Canadian Pacific "Crossing the Divide" scenario, but there is no coffee, which would generate 3 coffee demand for each cannery along with 3 demand for steel or aluminum. So does each cannery generate 3 demand for produce and 3 demand for steel and/or aluminum OR does it generate 3 demand for produce and 6 demand for steel and/or aluminum? (Note that between 1910 and 1930 canneries generate 6 demand each for produce and coffee and 6 each for aluminum and steel, because it's generating demand for all 4 possible permutations of input combination.) What's the deal with the demand model for Metra scenarios? These values mostly weren't included in jeffryfisher's extraction. It looks like the commercial and retail buildings convert commercial commuters (people coming from housing or the airport) back to residential commuters (people going back to housing) at a 1:1 exchange rate, but don't have stated demand values like the industrial conversion buildings. Maybe, if we're very lucky, all buildings have a fixed demand throughput in Metra. (There's only the one airport terminal though. So it'd be very sucky if it were limited to 6 carloads per year.) I also have no idea how depoting would work in the Metra. It looks like it would be convenient to offload people who want to go to the airport from the residential areas into the downtown district where dedicated airport shuttles would pick them up and take them directly, but it isn't clear that would work. Does 1.57 introduce new bugs while fixing the ones it did, and if so, is it worth trying to fix them? EDIT: Fixed some errors in the excel file on grain and fertilizer bonus production. RRT2 Demand.xlsx