PC Universal Pzb & Brake Calculator For German Content

That looks absolutely amazing. I used my own for passenger stock but the level of detail in here is unmatched. you definetely made me stop my break of tsw and get back to run some more hudless freight. can't wait to see the czech route release and be implemented.

 

Agreed, they’re the best routes in game.

 

Hi,
I think I found a bug.
When I enter a typical IC train set (1x 101, 2x Avmmz, 6x Bpmmz, 1x Bpmmbdzf) into the calculator, it displays incorrect maximum speeds on some routes.

Examples:
KWG: max 150 km/h both directions
DLG: Dresden - Leipzig 150 km/h, Leipzig - Dresden 200 km/h

And isn't the ZDE input based on the train's maximum speed and not the maximum speed of the track, meaning the input should always be 200 km/h?

 

Thanks for the report, currently it upgrades train to LZB/line speed only when it's capable of 160 km/h on the PZB section of the route, but yes, it should be 200 km/h.

 

Another bug with the 101 output, it tells me to enter BRA of 4 for a passenger consist.

 

Hah, I'm surprised that nobody noticed that before. I fixed that, and also adjusted the ZDE data so that it always shows consist speed for passenger trains that are allowed >= 160 km/h, that should resolve also the LZB running. "Max. speed" will still be given lower for the PZB part of the route where needed.

To update your spreadsheets, simply delete it from your google drive, go to the upstream one and perform "File - Make a copy" again.

 

I have the answer, but no one will like it.

Thank you for this amazing creation! Genuinely adds realism in things TSW misses.

 

Just a suggestion, maybe rename "BR 101 ZDE data" into simply "ZDE data" and include it into the list when the cab car is included in the consist as well? I know it's an edge case, but might help when using the cab car with something else (I sometimes use it with BR 218, for example).

Granted, most people who actually can drive the Expert stuff probably can discern the data from the main table.

 

I'll duplicate it in this thread.
Service PbZ2486 in the BR101 Expert package for Kassel Würzburg. Delivery of faulty wagons to the depot. How to correctly calculate train data if the brakes on one car are not working? I'm using Noir's spreadsheet, but it assumes all the cars have working brakes. I just need to change the train length and weight manually, am I right? And what about the speed limit?

 

You simply reduce the amount of waggons by the number of waggons that dont have brakes. Then you overwrite the length and weight of the train (cells O8 and O9) using the originally calculated values with those waggons still added. Et voila...

 

Thanks. I thought pretty much the same thing after reading the manual. But I needed confirmation.

 

I'm new to the Expert locos and I'm glad I found your spreadsheat ! With it's help I was able to make a list of all BR101 services and their ZDE values.

There are only 2 services that the spreadsheat can't calculate. On the SFS Kassel-Würzburg NJ490 and NJ491. Both have 10 AVMMZ and behind 2 Laaers. When I enter these, I get this:


I have already calculated the approx. Brake percent by adding the values of Weights and Braked Weights of Avmmz's and Laaers's. But can someone please tell me which PZB Mode and Brake Mode is appropriate in this case ? THANKS!

(oh, and please ignore the "Route:Chemnitz Hbf - Dresden Hbf" ;-)

 

The spreadsheet can not (yet) calculate combinations from freight and passenger Waggons.

But the other issue is that the Laaers are actually stand ins for the DDm’s, that are used on those trains irl. Those are not in the game. laaers have a max speed of 120, while the DDm is permitted to drive up to 160kph. They have an “R” brake setting as well, with more braked weight (I believe up to 66t).

 

Thanks for the explanation ! As there are only 2 services for the BR101 of this kind, it's not worth the time to change that in the spreadsheet...

And I just looked up the NJ 490/491 in the Online Ebula, here they both have a Vmz of 160.

 

Yes, in online-EBuLa the developer reads out the timetable (160 in this case). The brh are calculated from the Waggons used, hence they are probably wrong, however, the differences are minor so I would just go with the figures in there…

 

Amazing work! Glad to see this calculator continued being worked on! The Additional Speed Restrictions part of the calculator is exactly what I always wanted to be included but never asked haha. I have a few questions I must ask now though!

How should I approach the freight portion of the calculator if I encounter a freight train that has the first 5 wagons randomized together with the articulated ones? (e.g. first five wagons being 1-Zancs, 2-Zancs, 3-Sggmrss, 4-Shimmns-u, 5-Shimmns-u)
I encountered a few trains that were consisted in a similar way with 1 or 2 articulated wagons put in front with the rest. It is pretty rare but it can happen when choosing random freight trains in the game's timetables. What should I input when that happens?

And...

Are you planning on adding German EMUs and DMUs to the calculator in the future updates? (e.g. ICEs, BR423, BR442/BR1442 etc.)
For some of these I tried to find any kind of information about them to perhaps calculate BrH of their own but I couldn't find anything and there is no such info on the units themselves like others normally have.
But if the EMUs and DMUs would work in this calculator under the same conditions just like the Loco+Passenger wagons consists then it should be only the question of adding them to the list, no?

Thanks beforehand for answering. Cheers!!

 

The data are actually loco-dependent, and do not correspond 1:1 to just calculated BrH. For 101, you can find the translation sheet in the cab next to the data entry. For other locos, I don't have these materials available. This part of the calculator is not yet 100% finished, as I expect bigger changes there when 145 gets released.

I don't think this will actually work in all cases as you expect - the difference between expected and overwritten weight is distributed as load to freight wagons in the consist, so if you have just two wagons but 1000 tons, the calculator will place 500 tons (minus vehicle) into each wagon and work with that. I believe the correct way would be to add a new wagon to the list by copying the existing one, making something like "Eanos (brake off)", and altering its brake formula to correspond to disconnected brakes. It should be simple, just afterwards extend the field of zeroes on frontend to cover the new wagon as well.

Yes, they are intentionally throwing an error, because these consists are fictive and numbers wouldn't make any sense when using the ingame wagons (Laaers would degrade the whole consist to 120 km/h and P at best). I think the official timetables use two fictive wagons for now - DDm and Sggmrs 714/715. If someone has their side marking photos available, I can add them to the calculator.

The main reason to calculate articulated wagons differently is that both halves need to be set to same mode - you cannot have one half as "fifth" in G and one half as "sixth" in P. You can count the pair as two wagons, but ensure that they are set identically. So in your case, "GG(GG)GP..." should be correct.

Currently no plans to add multiple units, as their values are pretty much pre-calculated and fixed.

 

Thats what I found way back on Sggmrs 714:


And the DDm 915 (sorry for the bad quality, still the best I could find):

 

Ah, so the BRH translation sheet would differ... Understood.

Yes, I believe there are DDm-s that are 160km/h capable? They are used on real NJs.

 

After watching the broadcast of the new Czech route, a question immediately arose: is this calculator suitable for the Czech locomotive and carriages? Or are the calculation parameters for selecting the braking mode different in the Czech Republic?

 

Yes. The results do differ slightly due to local rules entering the calculation (mostly applying locally specific additional restrictions in some edge cases), but the general idea is shared among the whole UIC area, so they are mutually compatible. In fact, because some of the required materials are internal or not for public use in Germany, parts of my calculator stem from the czech D1 regulation instead, which is public and openly available to everyone.

Wagons in the LSP addon have working levers as usual, the markings on them will have local names (osobní/nákladní instead of P/G; prázdný/ložený instead of empty/loaded), but shape and color of the levers is precisely defined on UIC level exactly so that the language does not matter.

 

Great news. So everything will be added soon after the release, once the necessary data becomes available?

 

It is my plan

 

Hi,
it would be nice if there were a break percentage override field. This would help for trains with disabled breaks or faults where the brake wight of the locomotive change, so you could calculate the brake percentage by yourself and get the right vmax and ZDE data.

 

As written above, this would likely lead to unintended side effects. If you need wagon with different parameters, it's easiest to just copy existing one and adjust it to your needs.


Meanwhile - I added a pack of new stock into the calculator: 145, 750, Da-k, Eas, Roos, Sdggmrss, Zaes and fictive DDm (simply Laaers with 160 km/h).

As all the new expert trains (145, 750, 843) offer brake reports directly in the game, use those instead, as they take numbers directly from simugraph, while I take them only from textures and experiments. For the same reason the 145 currently does not offer calculation of ZDE data, as you have everything you need directly in the game already.

To add Da-k travelling office wagon, I had to touch some formulas (it's our first non-"s" wagon and also does not have any load), so let me know in case I broke something in the process.

Czech wagons have all the UIC controls identical with the German ones, and the calculations are generally compatible. If you are coming from Czech regulation instead and see German reports for the first time, braking of I. type is noted as "Mbr XX R/P" in the result, braking of II. type is noted as "Mbr XX G" in the result. See readme in the first post for more details.

Updating is simple, delete the previous copy of the spreadsheet from your Google Drive, open the upstream one and perform File - Make a Copy to create your own, editable spreadsheet.

https://docs.google.com/spreadsheets/d/1WgXR8LhyS2NMR_8GnGjc9EAd4-H1hbdqPLWcZiztimM/edit?gid=0#gid=0



If you want to support my creations and help me to get to new content early as it's released, you can do so on Buy me a coffee. Sign it with your forum or TSC nick so that I know who the supporters are Thanks!