Re: PAK128 Pricing & Balancing - Discussion Reply #35 – October 17, 2008, 02:07:48 pm Quote from: prissi – on October 17, 2008, 01:53:15 pmWell, the Napik was done ****uming five years to pay back for everything. That's only a decision we've got to take. I think at the moment the excel has ten years for locos...Quote from: prissi – on October 17, 2008, 01:53:15 pmWith the slower default flow of time, this is just one year three months. Slower flow? Has the game engine time flow changed? I mean, I know of the bits per month parameter that regulates the real play time, but has anything else been changed in the engine to alter time flow?? So 0,0113 squares/second is still valid using 19 bits per month or not? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #36 – October 17, 2008, 02:15:47 pm Yes, but the distance covered per year is now four (or eight) time larger => faster return of investment. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #37 – October 17, 2008, 02:38:19 pm Quote from: prissi – on October 17, 2008, 02:15:47 pmYes, but the distance covered per year is now four (or eight) time larger => faster return of investment.Four(eight) times bigger...?? I'm afraid I don't understand why at all :'(In the excel it's been calculated as 0,0113 sqares/second x 260 seconds/month x 12 months/year ... If 0,0113 is valid, and I hope a year still has 12 months!! So, it only remains 260 seconds/month (it's been used in the excel as DayLength, but I think it's wrong as later it uses DaysInYear=12); Anyway it's not explained anywhere. So I guess a month now isn't 260 real seconds, is it?Edit: Arrrrg!!! I hadn't noticed!! Four times more distance covered per year means much lower RC!!! Errr... won't really affect, I see Edit2: Is that (4x/8x) true for current stable (r1867), or is a new (nightly) implementation?? Quote Selected Last Edit: October 17, 2008, 03:31:30 pm by Zeno
Re: PAK128 Pricing & Balancing - Discussion Reply #38 – October 17, 2008, 03:33:24 pm x4/x8 is probably the change in bits_per_month from hard-coded to the new default values (depending on pak) configurable in simuconf.tab Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #39 – October 17, 2008, 03:44:56 pm Quote from: DirrrtyDirk – on October 17, 2008, 03:33:24 pmx4/x8 is probably the change in bits_per_month from hard-coded to the new default values (depending on pak) configurable in simuconf.tabThen the excel sheet might be correct, as it's written "19 bits/month", as in the default simuconf.tab... But 19bits/month means 2^19=524 seconds per month, not 260 Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #40 – October 17, 2008, 04:08:35 pm 262 would be 18 bits per month - and I think that was the hard-coded entry. So maybe the numbers are still from 18, and just the text has changed to 19...? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #41 – October 17, 2008, 04:35:02 pm Quote from: DirrrtyDirk – on October 17, 2008, 04:08:35 pm262 would be 18 bits per month - and I think that was the hard-coded entry. So maybe the numbers are still from 18, and just the text has changed to 19...?Mmm... might be. Anyway, some calculations are not based in distance (as average car/wagon income), and changing this value in the excel sheet makes things weird; i guess because of raw data used (saved data). It will need some update Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #42 – October 17, 2008, 04:37:43 pm I know. I've had Napik's Excel sheet for quite a while... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #43 – October 17, 2008, 06:09:37 pm Quote from: DirrrtyDirk – on October 17, 2008, 04:37:43 pmI know. I've had Napik's Excel sheet for quite a while... Actually I think one of the problems to solve is the average income of a wagon/car is pre-calculated, "raw" saved data. I think is a good way to use prissi's way of thinking on this: first get an average revenue per ton and km and then apply it to driven distance to get the expected yearly revenue. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #44 – October 17, 2008, 06:12:50 pm Go ahead - as long as it works, pretty much everything is acceptable! Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #45 – October 17, 2008, 07:00:35 pm Can anyone please tell me how to apply bonus levels? I wish to know how to convert the difference of speeds (vehicle_speed-bonus_speed) to the number of levels it represents. I guess if level of bonus is 3 then is applied the bonus 3 times... am I right? Or maybe is applied bonus*3? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #46 – October 17, 2008, 07:23:40 pm Well, not sure what you want. The money you get is:revenue*(1+((100*v_max)/v_speedbonus-100)*bonus_faktor/1000)v_max is the convoi top speedv_speedbonus the current speed according to speedbonus.tab (or the average speed of all engines of this category)bonus_faktor is between 0 and 18 in pak64, pak128 may differ ... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #47 – October 17, 2008, 09:12:19 pm Between 0 and 18 is true for pak128 also.And about how the numbers work - look a little earlier in this thread: http://forum.simutrans.com/index.php?topic=584.msg4852#msg4852 Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #48 – October 18, 2008, 09:27:08 am Quote from: prissi – on October 17, 2008, 07:23:40 pmrevenue*(1+((100*v_max)/v_speedbonus-100)*bonus_faktor/1000)Uh... seems quite easy... Quote from: DirrrtyDirk – on October 17, 2008, 09:12:19 pmAnd about how the numbers work - look a little earlier in this thread: http://forum.simutrans.com/index.php?topic=584.msg4852#msg4852Ups. Sorry for not searching before ask... Btw, I'll take a look... I think I'll have some nice calcs soon Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #49 – October 18, 2008, 06:51:57 pm If you look in cars.xls from pak64, there is already the formula used in the income column ... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #50 – October 18, 2008, 06:57:57 pm Quote from: prissi – on October 18, 2008, 06:51:57 pmIf you look in cars.xls from pak64, there is already the formula used in the income column ...Thanks, moreover it's also in this excel (somewhere in goods or bonus sheet).I've been doing a little remake of the excel... but I get revenues much higher than before... I must have made a mistake somewhere...Anyway, I attach the current xls here (I've deleted it from previous post).Edit: Actually, now revenues are more credible... they're more like 50 thousand cr/year or 120 thousand cr/year and so. Before they were like five thousand or so! But I get terribly higher RCs (if compared to previous). I think they wouldn't fit at all in ST. But I can't see what can be the causes to this If you could take a look, I've updated some explanations to keep it as easy as I could. Also remade the macro so ef speed is calculated a lot faster. Updated xls. Quote Selected Last Edit: October 19, 2008, 03:02:53 pm by Zeno
Re: PAK128 Pricing & Balancing - Discussion Reply #51 – October 18, 2008, 08:53:23 pm Well, taking into account that vehicles do not run always in straight lines, need more time than possible with max speed and are not always 100% filled, I used 10% of the maximum revenue for running cost for pak64. Maybe this would give sensible results too? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #52 – October 19, 2008, 12:40:28 pm So you suggest to use 10% of theorical revenue? I saw in this sheet was established a "efficiency" percentage, 75% for p**** and 48% for cargo (75% loaded p****enger in both runs; 95% loaded cargo in 1 run, empty on return = 48%). I think it's the same concept, but maybe you used a lower value. Actually, I get much more logical values for RC if I take 25% of income instead of 100%.Moreover, I've also introduced a new factor: bonus percentage applied. I think I can calculate the revenue using half (f.i.) of the possible bonus (maybe 75% or other value), as trains might not recieve always the maximum bonus value... Edit: Added updated xls. Quote Selected Last Edit: October 20, 2008, 08:46:02 am by Zeno
Re: PAK128 Pricing & Balancing - Discussion Reply #53 – October 20, 2008, 08:59:27 am Well, now the excel file looks quite nice. I managed to get new values with deviations between 25-30% vs old ones. I've added a couple of new things to the sheet: (In red background) at the begining of the sheet, there are two factors affecting ALL values of the locos, which are bonus and pricing percentage used to calculate RCs; also the average deviation for the whole pak (only locos).This two factors, are simple: how much of theoric max. revenue and bonus are used to get RC value. Using 12% of the max revenue and around 40% I get quite low global deviation, which means I don't get too away from what it is right now, while I keep % of max revenue near reasonable values (prissi says he used 10% for pak64).Note the deviation is in absolute value, so it's not a deviation from medium value but measures just deviation importance. The good thing is that the values are now calculated the same way for all locos in the pak, so they should be balanced. I think now it's just a matter of testing in-game and correcting (if needed).Now the purchase prices bother me, because I used 5 years payback to calculate it, but I *really* think 10 or even more years should be a more realistic value (despite being conscious it will be really hard to start a game with current values if vehicle's prices are two or three times higher). I place you to discuss also this; what do you think of increasing a bit vechicles purchase pricing, and also starting money for the player to compensate this?I leave the last version of the sheet for you to take a look. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #54 – October 20, 2008, 10:59:43 am Well done. I had a look at the loco purchasing prices and computed them using your Excel file for 10 year payback. In my opinion - and with the playing experience of the current pak128 - the prices are reasonable (I do not know however how significantly the profits changed from old to new system). We might need to adjust the starting capital to account for higher vehicle prices, but not too much - it seems to me that 500 thousands instead of 300 thousands should be more than enough. The question is, of course, what about the purchasing price of wagons - should it also use in future 10 year payback? It looks sensible. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #55 – October 20, 2008, 01:37:46 pm This is starting to look good! Thanks!What will be needed to transform the numbers into reality? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #56 – October 20, 2008, 01:43:10 pm Quote from: VS – on October 20, 2008, 01:37:46 pmWhat will be needed to transform the numbers into reality?Mmmm... I'll need all DATs to modify them, and lot of patience I guess... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #57 – October 20, 2008, 02:21:57 pm Give me a mail and we make a deal ;o) Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #58 – October 20, 2008, 08:06:47 pm About the 10%: This I used for engines, for wagon I used 1cr/ton/tile and for trucks 40%, for ships 48-49% and for planes 70% of the theoretical revenue. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #59 – October 20, 2008, 08:29:21 pm I haven't read all of the topic so I don't know what are you doing (I tried understand the excel sheet but ...)I would only know if the prices will increase or decrease ? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #60 – October 20, 2008, 08:51:50 pm Quote from: prissi – on October 20, 2008, 08:06:47 pmAbout the 10%: This I used for engines, for wagon I used 1cr/ton/tile and for trucks 40%, for ships 48-49% and for planes 70% of the theoretical revenue.Printed! I'll take them as reference values. Actually, I got best results for engines with aprox 10%, so I expect the others will be also quite similar. Thanks a lot prissi.Btw, I've developed a small tool which I use to m****ive replace values in DAT files. As I don't know how do you deal with DATs, I can provide the tool to the comunity when finished if you wish so.Edit:Quote from: gauthier – on October 20, 2008, 08:29:21 pmI haven't read all of the topic so I don't know what are you doing (I tried understand the excel sheet but ...)I would only know if the prices will increase or decrease ?Don't get scared! The prices may be rebalanced in near future; some can go up, some down, but not in a significant amount (20-30% in worst cases). We are trying to establish some basis and rules on how should running costs be calculated for all vehicles. Quote Selected Last Edit: October 20, 2008, 08:56:52 pm by Zeno
Re: PAK128 Pricing & Balancing - Discussion Reply #61 – October 20, 2008, 10:32:24 pm A side note- originally the excel was designed so that you could export the relevant part to csv and load into simutranslator - and vice versa. Now that it is not certain when it finally works 100%, I would really prefer to have this functionality doubled/backed up… Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #62 – October 21, 2008, 07:21:52 am Quote from: VS – on October 20, 2008, 10:32:24 pmA side note- originally the excel was designed so that you could export the relevant part to csv and load into simutranslator - and vice versa. Now that it is not certain when it finally works 100%, I would really prefer to have this functionality doubled/backed up…Uh? I had no idea about this. Could you please give a little detail of this process of data import/export? Is there a tool already done, or it's done with a script, or...? Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #63 – October 21, 2008, 09:03:49 am It's a feature of translator. You can upload a csv file with data for the vehicles. But I don't really know if it works or not, I never used it… Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #64 – October 21, 2008, 09:35:01 am Quote from: VS – on October 21, 2008, 09:03:49 amIt's a feature of translator. You can upload a csv file with data for the vehicles.Nice! Is there any documentation on file format expected? I mean the columns, order and so...Quote from: VS – on October 21, 2008, 09:03:49 amBut I don't really know if it works or not, I never used it…Uh, oh... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #65 – October 21, 2008, 10:02:49 am Ha, here:http://translator.simutrans.com/help/object_cvs.htm Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #66 – October 21, 2008, 10:24:53 am Nice, it does exacly the same than my tool (with some more fields), and externally looks like using quite similar formats and so... Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #67 – October 21, 2008, 11:00:45 am I've newly compiled the vehicles.all.pak with 10% revenue used to calc RC and purchasing costs about 2 or 3 times higher; that might be compensated by using higher player cash.I think these values will be quite equilibrated, as RCs appear to be a bit lower. I'll test tonight or tomorrow (and probably during the whole week) to play with these values and see what happens. If someone wants to test this beta pak, post here and I may publish it on a web/ftp site (german file hosting could be a good option). Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #68 – October 21, 2008, 04:47:38 pm Do not try this on the actual translator, as this only operated on pak with internal reference 0, which is now the base translation texts. Quote Selected
Re: PAK128 Pricing & Balancing - Discussion Reply #69 – October 21, 2008, 08:01:08 pm Quote from: prissi – on October 21, 2008, 04:47:38 pmDo not try this on the actual translator, as this only operated on pak with internal reference 0, which is now the base translation texts.Ok. I'll keep using my own tool for a while. If ever it's working back, will be nice to have a couple of ways to do it Quote Selected