Notice


PleaseĀ contact the NAVSEA program managers to request a copy of SECAT.


SECAT and OSTP: Excel Version

The most notable changes between version 1.0 and 1.2 are:

  • Software can support up to 10 Alignments (Old software only supported 5)
  • All data forms have been converted to Excel spreadsheets so that they can be filed out and saved to same location as SECAT file (Old software was PDFs)
  • The GPH and GPNM vs. Knots graphs allow the user to 'turn on/off' all curves via a simple checkbox next to each alignment.  These checkboxes are tied between both graphs and the OSTP tab (for example, if Alignment 4 is unchecked on the GPH graph, it will also be unchecked on the GPNM graph and OSTP tab)

There are also numerous minor changes incorporated in this version based upon user input since its introduction.


SECAT 1.0 Release Notes

Below is a list of limitations and differences between the original SECAT 1.0 and OSTP software and the new Excel version of the software.

Limitations:

  1. The newest Excel version of the SECAT 1.0 and OSTP software is limited to 5 plant alignments. If additional plant alignments are necessary, another copy of the program would need to be used.

  2. The newest Excel version of the SECAT 1.0 software has a limit of 15 trials per plant alignment for fuel consumption data.

  3. More than one set of trial data can not be saved internal to the Excel program. Instead, a new file must be created and saved for each set of SECAT data; it is suggested that a new file is created with a file name unique to the data set (i.e. SECAT 1.0 – Excel_ (DDG 52) 2010_3_17.xls)

  4. When using the OSTP to create a transit option, multiple transit options can not be compared simultaneously.

The limitations above could be resolved (with the exception of #3) within Excel; however, this would more than likely require a large amount of additional programming and/or an extensive built in macro to fully eliminate these limitations.

Differences:

  1. The original SECAT software utilized a 2nd order (quadratic) trendline to fit the GPH and GPNM data. The new Excel SECAT software utilizes a 3rd order (cubic) trendline to fit the GPH and GPNM data. This change was to allow the GPNM vs. Knots trendline to have a more accurate fit for determining optimum transit speeds and OSTP calculations.

  2. All data sheets, nomograms and agendas are hyperlinked in the program. The software will be delivered as a file folder containing the program and all the data sheets. It is imperative that the organization and file names within this file folder are not altered, otherwise hyperlinks could be disabled.

  3. The ‘Replenishment Requirements’ of the new Excel OSTP have been modified from the original OSTP. The original software only calculates to the day for replenishment; meaning that once the minimum threshold is reached, the total number of transit hours accrued is rounded up to the next 24 hour increment (i.e. if the minimum threshold is reached 2 hours into Day 2, the program calculates replenishment at 72 hours, not 50 hours). This method allows the ship to operate below the minimum threshold for up to 24 hours. In certain cases, the ‘fuel remaining onboard at the end of transit” is below the minimum threshold. The new program calculates the number of accrued transit hours until the minimum threshold is reached. As soon as this minimum threshold is reached, the program assumes the ship will replenish to the maximum threshold so as to never go below the minimum threshold. For this reason, the number of gallons per replenishment will always be the same regardless of plant configuration, and the fuel onboard will never reach below the minimum threshold.

The latest updated Excel version of the SECAT software, called "SECAT XL Version 1.3" is
located on the CD or available via
email. Because of all the forms associated with the software, the program has a file folder structure with several sub folders. The hyperlinks within Excel pull up the PDF files within those subfolders. You will need the entire folder, not just the Excel document.

Navigate to the root folder and locate the SEACAT XL Version 1.3 folder. Then copy the
SECAT XL Version 1.3 folder to your hard drive.

 

iENCON Incentivized logo