SUBSIM Radio Room Forums



SUBSIM: The Web's #1 resource for all submarine & naval simulations since 1997

Go Back   SUBSIM Radio Room Forums > Current crop of subsims & naval games > Wolfpack
Forget password? Reset here

Reply
 
Thread Tools Display Modes
Old 04-05-19, 07:12 AM   #1
Erwan
Swabbie
 
Join Date: Apr 2005
Location: France
Posts: 7
Downloads: 31
Uploads: 1
gear 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.

Wolfpack TDC.jpg

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

Features:
  1. 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)
  2. Recognition: 4 recognition filters (D6: I9) allow you to select up to 6 targets for the firing solution.
  3. The target designation uses the information of the 169 + 4 ships of the Game Recognition Manual available in the Early Access version.
  4. 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.
  5. 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).
  6. 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
  7. 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.

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

Last edited by Erwan; 04-05-19 at 02:04 PM. Reason: Formatting
Erwan is offline   Reply With Quote
Old 04-05-19, 08:20 AM   #2
Jonny-Dog
Sailor man
 
Join Date: May 2006
Posts: 44
Downloads: 142
Uploads: 0
Default

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

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

Jonny-Dog
Jonny-Dog is offline   Reply With Quote
Old 04-05-19, 08:29 AM   #3
Erwan
Swabbie
 
Join Date: Apr 2005
Location: France
Posts: 7
Downloads: 31
Uploads: 1
Default

Not really RP, i admit
Erwan is offline   Reply With Quote
Old 04-05-19, 09:26 AM   #4
Aktungbby
Gefallen Engel U-666
 
Aktungbby's Avatar
 
Join Date: Jul 2013
Location: On a tilted, overheated, overpopulated spinning mudball on Collision course with Andromeda Galaxy
Posts: 27,710
Downloads: 22
Uploads: 0


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

Erwan! AFTER A TWELVE YEAR SILENT RUN
__________________

"Only two things are infinite; The Universe and human squirrelyness; and I'm not too sure about the Universe"
Aktungbby is offline   Reply With Quote
Old 04-05-19, 01:17 PM   #5
Onkel Neal
Born to Run Silent
 
Onkel Neal's Avatar
 
Join Date: Jan 1997
Location: Cougar Trap, Texas
Posts: 21,276
Downloads: 534
Uploads: 224


Default

Quote:
Originally Posted by Erwan View Post

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:
  1. 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)

  2. Recognition: 4 recognition filters (D6: I9) allow you to select up to 6 targets for the firing solution.

  3. The target designation uses the information of the 169 + 4 buildings of the Game Recognition Manual available in the Early Access version.

  4. 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.

  5. 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).

  6. 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

  7. 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.

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.

Erwan/Grimsek


That looks amazing, can't wait to check it out later tonight !
__________________
SUBSIM - 26 Years on the Web
Onkel Neal is online   Reply With Quote
Old 04-05-19, 01:34 PM   #6
Erwan
Swabbie
 
Join Date: Apr 2005
Location: France
Posts: 7
Downloads: 31
Uploads: 1
Default

Quote:
Originally Posted by Aktungbby View Post
Erwan! AFTER A TWELVE YEAR SILENT RUN

indeed Aktungbby... but still not sunk ^^
Erwan is offline   Reply With Quote
Old 04-05-19, 01:47 PM   #7
raymond6751
Admirable Mike
 
raymond6751's Avatar
 
Join Date: Mar 2004
Location: Canada
Posts: 1,313
Downloads: 421
Uploads: 0
Default Danke

Thank you, sir.

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

__________________
My stuff:
https://www.authorsden.com/mikeraymond
raymond6751 is offline   Reply With Quote
Old 04-05-19, 02:01 PM   #8
Erwan
Swabbie
 
Join Date: Apr 2005
Location: France
Posts: 7
Downloads: 31
Uploads: 1
Default

Quote:
Originally Posted by Onkel Neal View Post
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...
Erwan is offline   Reply With Quote
Old 04-05-19, 05:17 PM   #9
snailer
Swabbie
 
Join Date: Mar 2019
Location: Italy
Posts: 10
Downloads: 8
Uploads: 0
Default

That is awesome, thank you guys!
snailer is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -5. The time now is 07:16 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright © 1995- 2024 Subsim®
"Subsim" is a registered trademark, all rights reserved.