SUBSIM Radio Room Forums - Wolfpack TDC Convoy Setup Tool

SUBSIM Radio Room Forums (https://www.subsim.com/radioroom/index.php)

- Wolfpack (https://www.subsim.com/radioroom/forumdisplay.php?f=277)

- - Wolfpack TDC Convoy Setup Tool (https://www.subsim.com/radioroom/showthread.php?t=240569)

Wolfpack TDC Atk Convoy Setup Tool

Hello Captains,
Here is a tool (google spreadsheet) dedicated to the duo Wolfpack Captain / Navigator to calculate all the parameters for a multi target shooting solution on a convoy.

Attachment 2778

Lien Google Sheet ==> WolfPack TDC Tool (1.03)

Features:

Location in convoy (D4: I5): to follow the evolution of the convoy during the approach, the positioning of priority merchants in a graphical way and the relative movement of the convoy makes it possible to preserve the the convoy diagram to prepare a multi attack target. (4 columns of 6 positions). (cell L3 and frame K2: T14)
Recognition: 4 recognition filters (D6: I9) allow you to select up to 6 targets for the firing solution.
The target designation uses the information of the 169 + 4 ships of the Game Recognition Manual available in the Early Access version.
Observation frame (D18:I23): Bearing, Mast height, length silhouette, focal used, side of AOB, situation "in aprroach" or "on the run", make it possible to calculate:
the Target Course by setting your heading (C25 cell), the AOB(D41:I41), the Distance(D34:I34), the firing sequence to enter the TDC.
Setting TDC : the speed can be calculated by the Hydrophone frame (K27: N34) with the RPM of a cargo ship and / or entered directly (D29: I29), or calculated by the pass out time (when uboot stopped) (D30: I30).
The Sequence of Fire (K15: U24) frame allows you to sort out the torpedo travel times by decreasing, and give the time gap to launch each torpedo for the most convergent impacts possible in less period. Estimated Tons to sink added :)
Resets Buttons : 1 for all inputs data, and 6x1 for each target cols. (Note you will have to accept Google Script on the first use)

Instructions :

Copy this sheet to access the entire tool.
The frames in yellow are for manual inputs (unprotected frames).
This tool was made in French but the Lang tab allows you to add your own translation of the dashboard
(for the basic data they are in the Ship_data tab (some FR criteria there).

I wish you Fair Winds and Following Seas in WolfPack, have fun Captains. :salute:

I thank Brolak who initiated the project on Discord WolfPack Game and that I tried to fairly enhance.

PS: if there are some bugs, let me know, I will try to fix it quickly.

WARNING! English-language Sailors, Spreadsheet is set in decimal comma by default (fr).
you may change country parameters in File/spreadsheet parameters of your copy...

Erwan/Grimsek

Hmmm...
Did they have Google Spreadsheets in 39-45?

I think I stick to pen, paper, and my stopwatch... :03:

Jonny-Dog

Not really RP, i admit :hmmm:

welcome aboard!....OR WELCOME BACK!!

Erwan!:Kaleun_Salute: AFTER A TWELVE YEAR SILENT RUN:Kaleun_Applaud:

Quote:

Originally Posted by Erwan (Post 2601429)

Location in convoy (D4: I5): to follow the evolution of the convoy during the approach, the positioning of priority merchants in a graphical way and the relative movement of the convoy makes it possible to preserve the the convoy diagram to prepare a multi attack target. (4 columns of 6 positions). (cell L3 and frame K2: T14)
Recognition: 4 recognition filters (D6: I9) allow you to select up to 6 targets for the firing solution.
The target designation uses the information of the 169 + 4 buildings of the Game Recognition Manual available in the Early Access version.
Observation frame (D18:I23): Bearing, Mast height, length silhouette, focal used, side of AOB, situation "in aprroach" or "on the run", make it possible to calculate:
the Target Course by setting your heading (C25 cell), the AOB(D41:I41), the Distance(D34:I34), the firing sequence to enter the TDC.
Setting TDC : the speed can be calculated by the Hydrophone frame (K27: N34) with the RPM of a cargo ship and / or entered directly (D29: I29), or calculated by the pass out time (when uboot stopped) (D30: I30).
The Sequence of Fire (K15: U24) frame allows you to sort out the torpedo travel times by decreasing, and give the time gap to launch each torpedo for the most convergent impacts possible in less period. Estimated Tons to sink added :)
Resets Buttons : 1 for all inputs data, and 6x1 for each target cols. (Note you will have to accept Google Script on the first use)

Instructions :

Copy this sheet to access the entire tool.
The frames in yellow are for manual inputs (unprotected frames).
This tool was made in French but the Lang tab allows you to add your own translation of the dashboard
(for the basic data they are in the Ship_data tab (some FR criteria there).

That looks amazing, can't wait to check it out later tonight !

Quote:

Originally Posted by Aktungbby (Post 2601458)

Erwan!:Kaleun_Salute: AFTER A TWELVE YEAR SILENT RUN:Kaleun_Applaud:

indeed Aktungbby... but still not sunk ^^

Thank you, sir.

Haven't tried it yet, but it looks very cool.

:Kaleun_Thumbs_Up:

Quote:

Originally Posted by Onkel Neal (Post 2601488)

That looks amazing, can't wait to check it out later tonight !

Your welcome Sir !

WARNING! English-language Sailors, Spreadsheet is set in decimal comma by default (fr).
you may change country parameters in File/spreadsheet parameters of your copy...

That is awesome, thank you guys!
:Kaleun_Applaud::Kaleun_Applaud: