PC Universal Pzb & Brake Calculator For German Content

Discussion in 'TSW General Discussion' started by noir, Oct 13, 2023.

  1. daanloman#3930

    daanloman#3930 Well-Known Member

    Joined:
    Feb 13, 2024
    Messages:
    841
    Likes Received:
    958
    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.
     
    • Like Like x 1
  2. ChengHo

    ChengHo Member

    Joined:
    Oct 17, 2024
    Messages:
    36
    Likes Received:
    45
    Agreed, they’re the best routes in game.
     
  3. jufiz#9670

    jufiz#9670 New Member

    Joined:
    Oct 10, 2021
    Messages:
    7
    Likes Received:
    4
    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?
     
  4. noir

    noir Well-Known Member

    Joined:
    Feb 16, 2020
    Messages:
    723
    Likes Received:
    2,250
    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.
     
  5. B-7

    B-7 Member

    Joined:
    Apr 10, 2024
    Messages:
    95
    Likes Received:
    91
    Another bug with the 101 output, it tells me to enter BRA of 4 for a passenger consist.
    Screenshot 2026-01-15 013451.png
     
  6. noir

    noir Well-Known Member

    Joined:
    Feb 16, 2020
    Messages:
    723
    Likes Received:
    2,250
    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.
     
    • Like Like x 2
  7. B-7

    B-7 Member

    Joined:
    Apr 10, 2024
    Messages:
    95
    Likes Received:
    91
    I have the answer, but no one will like it.

    Thank you for this amazing creation! Genuinely adds realism in things TSW misses.
     
    • Like Like x 1
  8. B-7

    B-7 Member

    Joined:
    Apr 10, 2024
    Messages:
    95
    Likes Received:
    91
    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.
     
  9. vodka#2734

    vodka#2734 Well-Known Member

    Joined:
    May 20, 2025
    Messages:
    563
    Likes Received:
    498
    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?
     
  10. OpenMinded

    OpenMinded Well-Known Member

    Joined:
    Feb 10, 2021
    Messages:
    1,420
    Likes Received:
    2,461
    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...
     
    • Like Like x 1
  11. vodka#2734

    vodka#2734 Well-Known Member

    Joined:
    May 20, 2025
    Messages:
    563
    Likes Received:
    498
    Thanks. I thought pretty much the same thing after reading the manual. But I needed confirmation.
     
  12. glendathu

    glendathu Active Member

    Joined:
    Sep 10, 2022
    Messages:
    164
    Likes Received:
    198
    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:
    NJ49#.jpg

    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" ;-)
     
    Last edited: Feb 5, 2026
  13. OpenMinded

    OpenMinded Well-Known Member

    Joined:
    Feb 10, 2021
    Messages:
    1,420
    Likes Received:
    2,461
    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).
     
    • Like Like x 1
    • Helpful Helpful x 1
  14. glendathu

    glendathu Active Member

    Joined:
    Sep 10, 2022
    Messages:
    164
    Likes Received:
    198
    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.
     
  15. OpenMinded

    OpenMinded Well-Known Member

    Joined:
    Feb 10, 2021
    Messages:
    1,420
    Likes Received:
    2,461
    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…
     
  16. sushizeraora#4838

    sushizeraora#4838 New Member

    Joined:
    Mar 17, 2024
    Messages:
    1
    Likes Received:
    0
    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!!
     
  17. noir

    noir Well-Known Member

    Joined:
    Feb 16, 2020
    Messages:
    723
    Likes Received:
    2,250
    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.
     
    • Like Like x 2
  18. OpenMinded

    OpenMinded Well-Known Member

    Joined:
    Feb 10, 2021
    Messages:
    1,420
    Likes Received:
    2,461
    Thats what I found way back on Sggmrs 714:
    upload_2026-2-10_14-27-2.png

    And the DDm 915 (sorry for the bad quality, still the best I could find):
    upload_2026-2-10_14-27-51.png
     
    • Like Like x 2
  19. B-7

    B-7 Member

    Joined:
    Apr 10, 2024
    Messages:
    95
    Likes Received:
    91
    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.
     

Share This Page