Results 1 to 4 of 4

Calculating Vessel Utilization in Budget Projections

Threaded View

  1. #1
    Registered User
    Join Date
    08-20-2014
    Location
    Lafayette, La
    MS-Off Ver
    2013
    Posts
    20

    Calculating Vessel Utilization in Budget Projections

    I am trying to calculate Vessel Utilization which in itself is not posing any problems but what is causing me problems is the fact that I am trying to do multiple calculations. I am trying to determine the number of days worked, Idle days, Repair Days in the same spreadsheet. I am trying to calculate the # of worked days based upon me changing the % of utilization but also to take into account a manual entry for Repair days and Shipyard Days.

    The attached spreadsheet shows what I am trying to accomplish and only the areas in yellow are editable cells, the rest should be calculated with a formula.

    Can someone point me in the right direction.

    Thanks
    Ray
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Calculating overall utilization percentage
    By haroon284 in forum Excel General
    Replies: 2
    Last Post: 09-05-2014, 06:42 AM
  2. Replies: 1
    Last Post: 01-06-2014, 06:34 PM
  3. budget formula. 2 different formulas for yearly budget SUMIF?
    By italianstallion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 05:20 AM
  4. Pulling weekly budget data into monthly budget
    By MarkRabbit in forum Excel General
    Replies: 4
    Last Post: 10-19-2008, 04:28 PM
  5. [SOLVED] Calculating monthly budget expenses
    By Warrain in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-15-2006, 07:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1