...
On the Bunkers form, click 
to initiate the Bunker Interpolator calculation.
Overview
The Bunker Interpolator uses daily ROB readings, along with data from the Boat Fuel Consumption Ratios Setup and Barge Fuel Consumption Setup forms to calculate estimated ROBs at arrival and departure and bunker consumption for each voyage leg. The data can be exported to a data warehouse where equipment performance can be analyzed and compared across various equipment owners to make more informed decisions.
...
The values calculated by the Bunker Interpolator appear on the Voyage Manager Bunkers tab and on the Voyage Bunkers form.
Total Fuel Consumption Calculation
The total consumption for a piece of equipment is calculated using the following formula:
...
- For equipment that joined or departed the tow during the period, the ROB value from the corresponding Delivery, Redelivery, Join, or Depart rows (On the Activity Log Equip In/Out tab) will be used instead of the ROB at period start or ROB at period end values.
- On the Activity Log Bunkers tab, if the Track Barge ROBs check box is not selected, the ROB value for barges will be zero.
- For a barge entering a tow, if the ROB value is not zero and Track Barge ROBs is not selected, IMOS assumes that the fuel onboard the barge is immediately consumed upon joining the tow. A row appears, representing this consumption.
- When Track Barge ROBs is not selected, you should not have a nonzero ROB for a barge departing the tow. If this situation occurs, the ROB amount will be used in the total consumption calculation.
Bunker Interpolator Calculation for Boats
- The Bunker Interpolator calculates the boat's total fuel consumption using the formula above.
- For each Laden, Ballast, and Hotel leg within the period, the Bunker Interpolator calculates the percentage of the overall period that the leg represents.
- For each fuel type that the boat consumed over the period, the Bunker Interpolator:
- Looks up the applicable row on the Boat form, using the number of barges as of the start date/time of the period. If the applicable row is not found, the Bunker Interpolator looks to the Boat Fuel Consumption Ratios Setup form.
- Using the fuel consumption data generated from the previous step, calculates the boat's ROB at each Arrival and Departure within the period.
- Assigns all fuel consumed during the period to the appropriate categories:
- When the fuel consumption period is entirely at port (between a Port Start and a Port End), the difference in ROB's is categorized as Hotel. If the fuel consumption period includes sea time and port time, then the Hotel consumption calculation is (Number of days in port) * (Daily Hotel consumption rate).
- The daily Hotel consumption rate is specified in the Hotel Gal/Day column on the Boat form. If the Hotel consumption rate is not specified on the Boat form, then the rate on the Boat Fuel Consumption Ratios Setup form will be used.
- The remaining fuel is categorized as Propulsion fuel, which is further divided into laden and ballast, depending on the ratios specified on the Boat form or on the Boat Fuel Consumption Ratios Setup form.
- Stop consumption is the fuel consumed during a Stop delay and is calculated similar to Port Consumption: (Stop delay days) * (Hotel consumption rate).
- For example, if the Stop delay is 1 day, and the Hotel consumption rate is 20 gal/day, the Stop consumption is calculated as 1 * 20 = 20 gal.
- When the fuel consumption period is entirely at port (between a Port Start and a Port End), the difference in ROB's is categorized as Hotel. If the fuel consumption period includes sea time and port time, then the Hotel consumption calculation is (Number of days in port) * (Daily Hotel consumption rate).
Bunker Interpolator Calculation for Barges
If the Track Barge ROBs check box is selected, a calculation is done for each barge that was in the tow over the period.
...