You are not connected. Please login or register

Blockade Admiral (Spreadsheet) Training Manual

Go down  Message [Page 1 of 1]

1 Blockade Admiral (Spreadsheet) Training Manual on Wed Sep 15, 2010 12:30 am

Tlzallen

avatar
top secret
Please do not post in this thread, as I'm working on a training section for the blockade app I'm working on. If we get the chance to give it a dry run in a non-sinking flotilla or event blockade, I want people to be able to view and review this as needed so they know how their portion of the spreadsheet works.

I will be dividing up the training into three parts, as follows:
  • Admiral Control Center
  • Vice Admiral / Quarter Master Control Center
  • Nav/XO Input Screen


Each section will link to the appropriate message for its training materials.

Thanks! please sign

2 Admiral Control Center on Fri Sep 17, 2010 1:21 pm

Tlzallen

avatar
Admiral Control Center

NOTE - DO NO ALTER ANY CELL REFERENCES WITHIN ANY OF THE BLOCKADE ADMIRAL SPREADSHEETS!

[You must be registered and logged in to see this image.]

The Admiral Control Center gives the fleet commander the ability to see the status of all ships on the blockade board, and those loading, simultaneously in real time. All of the data displayed on this screen is delivered from either the Vice Admiral/Quarter Master or the individual Nav/XO teams on the blockade board.

The Navigator, XO, Vessel Name and Vessel to Load information for each Nav/XO team is provided by the Vice Admiral/Quarter Master, while the Carp, Bilge and Crew information are provided by each individual Nav/XO team.

The only exception to this is the "Ships To Load" section. A smaller image of this section is seen below. As can be seen, after clicking on the cell to select what type of ship the Admiral wants to load, a small down arrow appears indicating that a Drop Down Menu (hence forth referred to as a DDM) is available.

[You must be registered and logged in to see this image.]

Clicking on this DDM gives the Admiral a selection of all vessel types available within YPP, as seen below.

[You must be registered and logged in to see this image.]

After a ship has loaded and sailed - as will be indicated by the Vice Admiral / Quarter Master on their screen - the Admiral will need to change the Vessel Type back to "Waiting".

NOTE - Vessel class variations (eg. Frost Sloop, Imperial WB, etc.) are not listed as they do not affect the performance or influence of a vessel.

IMPORTANT NOTE - Data from the Nav/XO teams can take as long as 15-20 seconds to populate due to the communication between spreadsheets. Keep that in mind when making assessments based on the provided data.



Last edited by Tlzallen on Sat Sep 18, 2010 9:03 am; edited 3 times in total (Reason for editing : spelling)

3 Vice Admiral/Quarter Master Control Center on Fri Sep 17, 2010 2:13 pm

Tlzallen

avatar
Vice Admiral/Quarter Master Control Center

NOTE - DO NO ALTER ANY CELL REFERENCES WITHIN ANY OF THE BLOCKADE ADMIRAL SPREADSHEETS!

[You must be registered and logged in to see this image.]

The Vice Admiral/Quarter Master Control Center allows the VA/QM to quickly and easily update the status of the fleet at a given moment. The spreadsheet is primarily driven by Drop Down Menus (hence forth referred to as DDM), with the bulk of data entry done well before the blockade ever begins.

[You must be registered and logged in to see this image.]

At the top of the spreadsheet is the "Ships To Load" section. The types of vessels that will be loading will be dictated by the Admiral, and are pulled in from his screen. However, the VA/QM indicates that ship's status. in the above image, the status line currently reads "--- Waiting In Line ---". When the VA/QM clicks on this cell, a down arrow for a DMM appears as seen below.

[You must be registered and logged in to see this image.]

When the VA/QM clicks on that down arrow, the DDM with the various options appears.

[You must be registered and logged in to see this image.]

The VA/QM simply selects that appropriate status and the information is then transmitted to the Admiral.


The VA/QM also assigns the Nav/XO teams to their ships. Here again, clicking on a cell and selecting the appropriate name gets the job done quickly.

[You must be registered and logged in to see this image.]

The names on the list are taken from the Navigators List seen at the bottom-right of the above image. The names can be entered well in advance of the blockade and then used as needed.

The same actions are used for selecting an XO for each team. And likewise, the list of XOs is populated from the list of names located in the lower-right of the above image.


The VA/QM must also select a Vessel and a Vessel To Load for each team. While clicking on this cell also brings up a DDM of available vessels, there is an added function built into spreadsheet to help the VA/QM keep their list of ships current.

[You must be registered and logged in to see this image.]

As seen above, when the DDM appears it lists the ships in the order that they appear in the Vessels list, located in the lower-left corner of the image. (More on how to enter ships later in this post) For now, we are going to focus on the Decent Haddock, circled in red in the above image. We are going to assume, for the sake of this tutorial, that is has been sunk.

[You must be registered and logged in to see this image.]

In the Vessels list, located in the lower-left corner of the image, you can see that we have now placed an "x" in the column for "sunk". From this point on, whenever the VA/QM pulls up a Vessel DDM, the Decent Haddock, and any other sunk ships, will be eliminated from the menu. This function allows for simple bookkeeping of what ships the fleet came in with, lost and still have available with a single keystroke.


When entering which vessels will be used by the blockade fleet, it is suggested that each ship be typed in by class and with a class indicator (eg., WB, WF, GF) so that each team and the Admiral can more easily find them. This will also help with any fleets that have multiple ships with the same name, but that are of different sizes.

4 Nav/XO Team Input Panel on Fri Sep 17, 2010 2:24 pm

Tlzallen

avatar
Nav/XO Team Input Panel

NOTE - DO NO ALTER ANY CELL REFERENCES WITHIN ANY OF THE BLOCKADE ADMIRAL SPREADSHEETS!

[You must be registered and logged in to see this image.]

Each Nav/XO team has its own input panel to relay the current state of its ship to the Admiral. There are panels for ten (10) teams, named as follows: Alpha, Beta, Gamma, Delta, Epsilon, Zeta, Nu, Sigma, Tau and Omega.

It is strongly recommended that the XO be the person inputting the data into the Nav/XO panel, as the Navigator has to far too many enemies to avoid, strategies to employ and, most importantly, flags to hold during the blockade.

The Nav/XO panel is designed to sit on the side of the game screen, much like the QuarterMaster II program for pillages.

Inputting data into the three (3) cells on the input panel requires nothing more than selecting the cell, typing in the estimated damage or bilge level, and hitting return. The crew aboard can be updated in the same manner.

The Nav/XO team also has the name of the next vessel their crew will load, found in the fourth gray bar at the top of the image. This information allows the XO to convey where his crew should go next, be it because of a sink or the round ending, and should allow for a quicker transfer of personnel during the battle.

Please note that the system can take as long as 15-20 seconds to convey information to the Admiral. So timely entering of data is essential.

Sponsored content


Back to top  Message [Page 1 of 1]

Permissions in this forum:
You cannot reply to topics in this forum