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:
    720
    Likes Received:
    2,243
    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:
    94
    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:
    720
    Likes Received:
    2,243
    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:
    94
    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:
    94
    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:
    532
    Likes Received:
    447
    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,418
    Likes Received:
    2,451
    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:
    532
    Likes Received:
    447
    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:
    163
    Likes Received:
    192
    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 at 6:58 PM
  13. OpenMinded

    OpenMinded Well-Known Member

    Joined:
    Feb 10, 2021
    Messages:
    1,418
    Likes Received:
    2,451
    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:
    163
    Likes Received:
    192
    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,418
    Likes Received:
    2,451
    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…
     

Share This Page