JP6910749B1 - Bunkering support system - Google Patents

Abstract

PROBLEM TO BE SOLVED: To provide a bunkering support system in which a fuel supply company and an engineer can easily agree whether or not a required fuel has been loaded while avoiding a risk of calculation error during bunkering. SOLUTION: In a ship's fuel loading operation (hereinafter referred to as bunkering), a tank table 13 which is a fuel tank design value peculiar to the ship and various data required for bunkering are calculated in a computer 10. The bunkering calculation program includes a table data display unit for visually confirming that the value of the tank table and the table data used by the computer for the calculation match. It is provided with a data input unit capable of inputting various ship data indicating the oil temperature, specific gravity, and inclination state of the ship, and a result display unit 12 for visually displaying the calculation result. [Selection diagram] Fig. 2

Description

The present invention relates to a bunkering support system capable of reducing the calculation burden and negotiation burden of an engineer during fuel loading work (hereinafter referred to as bunkering) in a large ship such as a tanker.

Patent Document 1 estimates using a complicated model in order to calculate the liquid level of a liquid storage container such as a moving fuel tank.

Special Table 2014-502742 Gazette

However, even if tankers and the like use these complicated liquid level models when loading fuel at each port of call, it is not possible to obtain an agreement between the workers of the refueling company and the engineer, and the request is made. It is difficult to confirm whether or not the fuel has been reliably replenished.

For example, when a tanker departs with the fuel limit capacity satisfied, the engineer calculates the fuel consumption during navigation from the load capacity, weather, etc., calculates the fuel required for the next navigation, and asks the refueling company. Order the required fuel. In the case of general vehicles, fuel gauges are provided in both fuel supply facilities such as gas stations and fuel tanks on the vehicle side, and the desired amount of liquid is supplied according to the indication of the fuel system. Therefore, there is no room for doubt about those figures. However, facilities installed at overseas ports of call that supply fuel to large ships such as tankers are not equipped with fuel gauges on the facility side. In addition, the discretion of the workers on the fuel supply company side has a great influence, and in a state where there is a shortage of about 50 tons, the completion of refueling may be notified in a straightforward manner. The fact is that the tanker side also uses the liquid level height in each fuel compartment as a fuel gauge instead of a fuel gauge, and the engineer was created by the shipbuilding company when the tanker was built, and the dimensions of each fuel tank are Based on the described book (hereinafter referred to as the tank table), calculate the liquid level when the ordered amount of oil is refueled, and use this calculation result to negotiate with the workers of the fuel supply company. At the same time, it is confirmed that the fuel as ordered has been loaded. This negotiation is extremely stressful, and proper bunkering will not be completed unless negotiations are concluded with the fuel supply company.

Here, the above-mentioned tank table is a value unique to each ship, and the information described in this tank table is treated as correct by any fuel supply company in the world. Therefore, it is very effective to negotiate with local workers based on the tank table. However, if the manual calculation is performed on the spot by relying on the tank table, there may be a violent exchange with the fuel supply company regarding the presence or absence of calculation errors. In addition, if the engineer makes a calculation error, even if the fuel supply company supplies the correct fuel, there is a serious problem that the fuel runs out and drifts during the voyage, and the excess fuel increases the weight and fuel efficiency. There was a risk of deterioration.

An object of the present invention is to provide a bunkering support system that avoids the risk of calculation errors during bunkering and allows the fuel supply company and the engineer to easily agree on whether the required fuel has been loaded. ..

In the present invention, can be input and table data display unit capable of visually that the value of the table data tank table of values and the computer uses to compute by bunkering calculation program are the same, the predetermined ship data data It is equipped with an input unit and a result output unit that visually displays the calculation result by the bunkering calculation program.

Therefore, while avoiding the risk of calculation errors, it is possible to carry out refueling work while checking the calculation process with the fuel supply company workers, and it is possible to smoothly check whether the required fuel has been loaded during bunkering. , The fuel supply company side and the engineer can easily agree.

It is a schematic diagram of the tanker using the bunkering support system of Embodiment 1. It is a system schematic diagram which shows the bunkering support system of Embodiment 1. It is a table when the Tank Condition List of an Example was created. This is an information input screen before bunkering of the embodiment. This is an information input screen after bunkering of the embodiment. It is the schematic which shows the tank of the ship which is the calculation target of an Example. It is the schematic which shows the tank of the ship which is the calculation target of an Example. It is the schematic which shows the Draft and Trim of the ship of an Example. It is a table showing a part of the tank table for correction based on Trim of No. 1 D.O.T (P) of an Example. It is a screen which corrects Volume based on Trim with reference to the tank table of Trim shown in FIG. It is a table which shows a part of the tank table for the correction based on the Heel of No. 1 D.O.T (P) of an Example. It is a screen which corrects Volume based on Heel by referring to the tank table of Heel shown in FIG. It is a conversion coefficient table of the temperature-volume conversion coefficient of an Example.

[Embodiment 1]
FIG. 1 is a schematic view of a tanker using the bunkering support system of the first embodiment. The tanker 1 has a plurality of tanks 20 to 25 for storing fuel for navigation. The tanks 20 to 25 are partially designed for light oil fuel and part for heavy oil fuel, and the fuel consumption differs depending on the type of fuel. Therefore, the fuel consumption and the required fuel are calculated according to the type of fuel. When calculating how much fuel is loaded in the tank, it is calculated based on the gap height between the liquid level of the fuel and the upper surface of the tank (hereinafter referred to as the liquid level height). Since the ship has an inclination angle (trim) in the front-rear direction and an inclination angle (heel) in the left-right direction depending on the state of cargo, these trims and heels can be measured and necessary corrections can be made accurately. Calculate the liquid level.

The engineer calculates the fuel consumption according to the cruising condition and the cruising distance, and calculates the liquid level corresponding to the current remaining fuel. Then, the fuel loading amount is calculated based on the fuel required for the next navigation, and the liquid level height is calculated according to the fuel loading amount. Then, the fuel supply company at the port of call is informed of the required fuel (hereinafter referred to as the required fuel) and requested to load the fuel.

Workers of the fuel supply company load fuel into each tank. At this time, the engineer knows the liquid level reached when the fuel is loaded, visually confirms whether or not the fuel has been loaded to that liquid level, and confirms with the fuel supply company side. After working and reaching an agreement, sign the receipt. On the other hand, when the fuel supply company claims to have loaded the required fuel and asks for a signature on the receipt, if the liquid level does not reach the level recognized by the engineer, sign the receipt. Instead, demand that the fuel be loaded until it reaches the required fuel.

The bunkering support system is used in the calculation of the liquid level and the negotiation with the fuel supply company as described above. FIG. 2 is a schematic system diagram showing the bunkering support system of the first embodiment. The tank table 13 is a book created by a shipbuilding company at the time of tanker construction and describing the dimensions of each fuel tank. This tank table 13 is always attached to each ship. The computer 10 with a display screen includes a monitor 12 as an information input screen and an information display screen, and a keyboard 11 for inputting data. The monitor 12 displays a data input unit 30 capable of inputting various information such as oil level height information, oil temperature information, heel, and trim.

Further, the table data sheet 31 referred to by the calculation unit 32 at the time of calculation is visually configured. The table data sheet 31 is set with the same information as the dimensions of the fuel tank described in the tank table 13, and is configured so that the information on the tank table 13 and the table data sheet 31 can be visually compared.

The calculation unit 32 refers to the information set in the table data sheet 31 and calculates the liquid level reached when the required fuel is loaded into the current fuel based on the information input to the data input unit 30. do. The monitor 12 displays a result output unit 33 that can be visually recognized by displaying the calculation result of the calculation unit 32. According to this system, the engineer can input various information and easily grasp the calculated liquid level. These calculations can be used by appropriately utilizing spreadsheet software and the like.

Here, after notifying the fuel supply company of the required fuel and starting loading the fuel, the fuel supply company side is responsible for the fuel even though the liquid level is considerably lower than the liquid level that the engineer knows. You may be asked to sign the receipt as the loading is complete. At this time, the engineer brings the tank table 13 and the computer 13 with a display screen to the worker of the fuel supply company, shows that the information of the tank table 13 and the table data sheet 31 match, and the result. The liquid level indicated by the output unit 33 is presented, and it is visually indicated that the fuel loading is not completed.

As a result, accurate calculation results can be obtained by computer calculation instead of manual calculation by the engineer, and the workers and engineer of the fuel supply company can confirm that the calculation result refers to the data that matches the tank table 13. It can be easily confirmed between. Therefore, it is possible to avoid disputes such as calculation errors, refuse to sign the receipt, and request that the fuel be loaded to the liquid level according to the required fuel.

The specific configuration of the bunkering support system will be described below.
(Example)
In this embodiment, Microsoft Excel (registered trademark) will be used as spreadsheet software. The Tank group of the Work Sheet has Shee1 (Tank), Sheet2 (Trim), and Sheet3 (Temp). Sheet2 describes the Tank Table (available for each ship). This is copied from the tank table 13. This includes the Trim table and Heel table. Use these tables to correct the bow and stern tilts and lateral (starboard, port) tilts of the ship. If the temperature changes, the volume changes and the specific gravity changes, so use the Sheet3 table to correct it. 6 and 7 are schematic views showing the tank of the ship to be calculated in this embodiment, and FIG. 8 is a schematic view showing Draft and Trim of the ship.

(About Tank Condition List)
FIG. 3 is a table when the Tank Condition List is created. First, create a blank Tank Condition List. If this table is made, (1) the amount of oil on hand at the time of arrival at the port, (2) the amount of oil on hand at the time of departure, (3) the remaining amount before Bunkering (loading of oil), (4) the remaining amount after Bunkering (loading amount) And total amount) That is, you can see how much you received at Bunkering. You can make an estimated loading amount table for each tank at the time of Bunkering. Therefore, it is possible to calculate the expected Ulrage of each Tank at the time of loading. Ullage is {the distance from the upper end of the Sounding Pipe (Pipe to put the Scale) to the oil level}. Sheet2 and Sheet3 are used to make this table.

The columns for each tank (118,120,122,143,145,147 in the leftmost column) are the current amount, and the columns below it (119,121,123,144,146,148) are the end of Bunkering (fuel loading). Represents the current amount of time (excluding Sett.T & Ser.T).
Full Capa .: Depth and maximum capacity of each Fuel Oil Tank (FOT) (volume tonnage m ³ )
Sound: Sounding: Sounding, distance from the top of the oil to the bottom of the tank (m)
Volume Adjusted by Trim: Volume adjusted by changing the trim (m ³ )
Heel Adjust: Adjusted amount by left / right tilt (Heel)
^{True Volume: Capacity (m 3} ) on which the calculation is based (horizontal)
FOTemp: Actual FO temperature (℃), generally seawater temperature, mixed oil temperature (℃) after loading fuel, seawater because the tank in use is heated to 40-45 ℃ Different from temperature.
T-Volume Factor: Temperature-volume conversion factor. Volume changes if the oil temperature is different. Computer selects from this coefficient.
Density: Density or SG (Specific Gravity): Specific Gravity (mostly Density in foreign countries)
Remaining Loading Oil: Amount of residual oil The upper column is the amount of residual oil, and the lower column is the amount of residual oil at the end of loading. Therefore, subtracting the upper column from the lower column gives the loading amount (m / t).
Total Quantity: Total quantity at the end of loading the tank (m / t)
Load Pct: Ratio of the amount of oil in the Loading Tank to the maximum capacity (%)
Quantity Received: Total loading amount (m / t)
Quantity in Total: Total amount of FO for the entire ship (residual oil amount before loading + loading amount) (m / t)
FO Sett T: FO Settling Tank (m ³ ) in Engine Room (* DO Sett. Tank does not exist because this ship is a small ship)
FO Ser.T: FO Service Tank (m ³ ) in Engine Room (* Many large ships have two)
Draft: There is a bow draft and a stern draft. Distance from the bottom of the ship to the surface of the water (m)
Trim: Difference between Stern Draft (After Draft) and Bow Draft (Fore Draft) (m) (* Usually measured by Chief Officer)
SWT Sea Water Temperature: Sea Water Temperature
ERT Engine Room Temperature: Engine Room Temperature (℃)

FIG. 4 is an information input screen before bunkering. Enter the measurement data in the gray cell (Cell). When data is input from the next time, it will be superimposed from the previous value. Instead of erasing it once and then inserting it, enter it from the top of the previous Data. In the blank Cell, calculate and input only when issuing Trim. Sometimes I say Trim instead of Draft, so fill in Trim at that time (no calculation required).

FIG. 5 is an information input screen after bunkering.
The gray cell shows the measurement data, the FO (temperature, specific density or Density) of the contact from the barge is in columns 40 and 47, the DO (temperature, specific density) is in columns 51 and 58, and the target Ulrage of the final oil is Right side of columns 44, 45, 46 (final target Ulrage). Enter the maximum capacity of FOT and DOT Full Capa. In Fig. 3 from the beginning. It is listed in the Tank Table.

Next, the measurement data is input into the gray cell (Cell) of FIG. 4 in the order of the following numbers.
1. 1. Sea Water Temperature 30 (℃)
2. Engine Room Temperature (℃)
3. 3. Fore Draft 6.60 (m) (The value is in this case. An example)
Four. After Draft8.00 (m) (The value is in this case. An example)
Five. Trim is calculated by (After Draft-Fore Draft) (m)
6. Heel looks at the instrument in the aisle (central part) or bridge. The unit is Degree.
7. 7. Density is the density of residual oil (Density @ 15 ℃), and when new oil is loaded, it becomes the mixed density and the value of all FOT changes. No.2 FOT (S).
8. Density (or Specific Gravity) No.3 FOT (P).
9. Density (or Specific Gravity) No.3 FOT (S).
10,11,12 are FOT Sounding (oil level depth). Normally, the Sounding tape (tape measure) is very dirty, so measure from the top surface of the sounding tube to the oil level (Ullage). Then, subtract Ulrage from the height of FOT to calculate the sounding value.

The No. 2 FOT (S) (A118, A119) (total height and maximum volume of the tank) of the Tank Condition List is the value entered by referring to the Tank Table. If you enter 9.19 (B118) of No.2 FOT (S), S127 will be calculated automatically.
B118-T127 = S127 (5.09 in this case).
When indicating the location of 9.19, describe as (B118).
Other FOTs (No.3 FOT (P), No.3 FOT (S)) also operate in the same way. Then, enter the same number in the dark gray cell on the left as shown by the arrow (←). This is to prevent circular references.
13, 14 and 15 are the FOT oil temperature (℃). Generally, it is the same as the seawater temperature. The tanks that are about to be transferred are heated and need to be measured, but for any ship, one tank (for ships using FO) is heated (35 ° C to 45 ° C). It is assumed that the No. 2 FOT (S) (tank on the starboard side of the bow) is currently in use.
16. FO Sett.T temperature (℃)
17. FO Ser.T temperature (℃)
18. Volume of oil in FO Sett. Tank (m ³ )
19. Volume of oil in FO Ser. Tank (m ³ )
31.No.2 FOT (S) Ulrage (m) In this case, 4.10
32. No.3 FOT (P) Ulrage (m) In this case, 5.50
33. No.3 FOT (S) Ulrage (m) In this case 6.00

Next is DO.
20. No.1 DOT (P) Density
21. No.4 DOT (P) Density
22. No.4 DOT (S) Density
Nos. 20, 21 and 22 are the Densities of residual oil so far.
23. No.1 DOT (P) Sounding. In the case of DOT, the oil is clean, so measure the actual depth without measuring with Ulrage (Sounding) (0.11m). It's almost empty.
24. No.4 DOT (P) Sounding. Almost empty tank (0.22m)
25. No.4 DOT (S) Sounding. This Tank is almost empty, but a little remains (0.33m).
Oil temperature (℃) of 26, 27, 28.3 DOTs
29. DOSer.T Volume (m ³ )
30.DOSer.T oil temperature (° C), usually engine room temperature, not heated.
This completes the input of data (Data) when measuring the amount of oil on hand (residual oil amount) at the time of normal departure and arrival at the port. The answer comes out the moment you enter 33. J131 and J154.

FIG. 9 is a table showing a part of the tank table for correction based on Trim of No. 1 D.O.T (P). Each tank has a table showing the correspondence of Sounding to Trim (m). FIG. 10 is a screen for correcting the volume based on the Trim with reference to the tank table of the Trim shown in FIG.

(1 created by Soft)
You can understand it well by operating while looking at (how to make software) of the computer.
The basis of No.1 DOT (P) is Sounding A, cell J7 (0.11). Inspect this. ^{First, the number of tons (m 3} ) contained in this tank is calculated from the Sounding cell A (0.11) and Trim cell C (1.40) of the No. 1 DOT (P) described above. Look for this in the Tank Table. Sounding's 0.11 means in this case. Please note that it will change. This 0.11 finds the number from the top of the leftmost column of the Tank Table. For that, we use the Match function. You can see fx on the upper left side. This is the mark of the function. Operate in the order of the numbers below. This function is used to find the order.
Click cell B (K7), click fx, click MATCH, click OK, click inspection value, click cell A (J7), click inspection range, A5; A923, (A5 to A923) specified (A5 to A923) Drag), click the match type, and enter 1. Click OK and get 12. In other words, Sounding0.11m indicates that the line number is the 12th from the top. It is convenient to link (Q148) to cell A (J7).

Next, find the number before Trim of No.1 DOT (P). The previous number is the integer part of Trim 1.40m. 1.40m in this case means that it is between 1m and 2m. The previous number 3 indicates that it is the third column from the left. Similarly, the latter number, 4, indicates that it is in the fourth column from the left.

Next, cell H in (L15) shows the intersection of the number of columns 3 of the previous number 1 and the number of rows 12 of Sound.0.11. This is the tonnage of the previous few 1m. Similarly, the intersection of the 12th row and the 4th column is the tonnage of the latter few 2m. The number at (1.4 m) between these two tonnages is the true tonnage (m ³ ). The number obtained by calculating this by proportional distribution is Result1 and cell K (J15) (in this case, it is 0.38).

(How to find the number cell D (L11) before No.1 DOT (P) Trim)
Use the HLOOKUP function. Click cell D (L11) (click the cell you want to find). Click the function symbol fx, click HLOOKUP, click OK, click the search value, click cell C (J11), click the range, enter B4; H4 (read from B4 to H4), from B4 ~ H4) Specify (drag) and click the line number. (Because it is the first line from the top, enter 1), the search method is 1, click OK, and get 1.
Click cell L11 and look to the right of the function symbol Fx. You can see HLOOKUP (J11, B4; H4, 1, 1). It shows how to find L11. Indicates the type of function (search value, range, line number, search method).

(How to find the number cell E (M11) after No.1 DOT (P) Trim)
This also uses the HLOOKUP function.
1. Click cell E (M11). (This is the cell you are looking for from now on).
2. Click the function symbol fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J11),
6. Click on the range,
7. B4; H4 (from B4 to H4) designation (drag),
8. Click the line number,
Enter 9.1,
10. Enter 1 in the search method, enter +1 in the formula to the right of fx,
11. Click OK to get 2.
From the above, we can understand how to find the number before and the number after.

Next, how to find the number of columns cell F before the No. 1 DOT (P) Trim will be explained. This finds out in what column (vertical) the previous number (cell D) above is. Use the Match function. Note that the terms of the search order are different between the Match function and the HLOOKUP function. Check what column the previous number is in. First, find the previous number of cells F.
1. Click cell F (L13),
2. Click fx,
3. Click Match function, click OK,
4. Click the inspection value,
5. Click cell D (L11) (remember exactly where to inspect).
6. Click the inspection range,
7. B4; H4 (B4 to H4) designation (drag),
8. Click the collation type, enter 1,
9. Click OK to get 3.

Next, find the number of columns and cell G after No.1 DOT (P) Trim. This finds out what column the latter number is in. Use the Match function. Operate in the order of the numbers below.
1. Click cell G (M13),
2. Click Fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M11),
6. Click the inspection range,
7. B4; H4 (B4 to H4) designation (drag),
8. Click the match type, enter 1 and click OK,
Get 9.4. It means the 4th row.
Now Sounding A (0.11) has a row number of 12, the number before trim (cell C) (1.40) has a column number of 3, and the number after trim (cell E) has a column number of 3. It turns out that is 4.

Next, the cell H of No. 1 DOT (P) is obtained. Cell H is the intersection (volume) of the row number (12) of Sounding (cell A) and the column number of the previous number. Here, the INDEX function is used. First, find the intersection of the column number of the previous number and the number of rows of Sounding.
1. Click cell H (L15),
2. Click fx, click OK,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array (usually clicked),
6. Specify all tonnage displays (drag). Drag from the upper left corner to the lower right corner. Write B5; H923. (B5 to H923) Designation (drag),
7. Click the Sounding line number, click cell B (K7),
8. Click the column number, click cell F (L13),
9. Click OK to get 0.42.

Next, find the intersection of the column number of the number after No. 1 DOT (P) and the number of rows of Sounding. The operation method is the same as the method of finding the intersection of the column number of the previous number and the number of Sounding rows. Use the INDEX function. The INDEX function is a function used to find the intersection.
1. Click cell J (M15),
2. Click fx, click OK,
3. Click INDEX, click OK,
4. In the argument selection, click OK (do not touch anywhere),
5. Click on the array (usually clicked),
6. B5; H923 (B5 to H923) designation (drag),
7. Click the line number,
8. Click cell B (K7),
9. Click the column number, click cell G (M13),
10. Click OK to get 0.33.
This will give you the tonnage of the front and back numbers.

Next, we need to find the number at trim 1.4 between cell H and cell J (ie between 0.42 and 0.33).
This is calculated by the following formula. Proportional distribution.
Result_1 = L15-(L15-M15) * (J11-L11)
Link Result_1 to the cell (D143) of Tank Condition List.
Volume Adjusted by Trim of No.1 DOT (P) is over. It works even if the Soundinng and trim are changed. This completes 1 of Soft creation.

(2_Heel created by Soft)
FIG. 11 is a table showing a part of the tank table for correction based on Heel of No. 1 D.OT (P), and FIG. 12 is a correction of Volume based on Heel with reference to the tank table of Heel shown in FIG. It is a screen to perform.
Perform Heel Adjust for No.1 DOT (P). First, in the above cell table, Sounding A already contains 0.11. Find the Sounding row in the HeelCorrectionTable.
(1) Click cell B (K903), click the function symbol fx, click Match, click OK, click the inspection value, click cell A (J903), click the inspection range, J64; J157, (From J64 to J157) Specify (drag), click the type of collation, enter 1 and click OK to get 2. The Match function uses the check value, check range, and match type.

Next, find the previous few cells C (L906) at the time of Heel (+1.5 degrees) of No. 1 DOT (P). Use the HLOOKUP function. Specifically, click cell C (L906: cell to be calculated), click fx, click HLOOKUP, click OK, click search value, click cell E (J906), click range, K63; Specify (drag) Q63 (from K63 to Q63), click the line number, enter 1, click the search method, enter 1, click OK, get 1.

Next, the number after No. 1 DOT (P) is also calculated in the same way. Use the HLOOKUP function.
1. Click cell D (M906),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell E (J906),
6. Click on the range,
7. (K63; Q63: from K63 to Q63) Instructions (drag),
8. Click the line number,
9. Put in 1,
10. Click the search method, enter 1,
11. Add +1 to the formula on the right side of fx,
Get 12.2.

Next, find the number of columns before No.1 DOT (P). Check what column (previous number 1) is. Use the Match function. Operate in the order of the numbers below.
1. First, click on the desired cell F (L908),
2. Click the function symbol fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell C (L906),
6. Click the inspection range,
7. Instruct (drag) ~ Q63 from K63 and write (K63; Q63).
8. Click the collation type,
9. Enter 1, click OK and get 5.

Next, find cell G (M908) of No. 1 DOT (P). Use the Match function. Find out what column the latter number 2 is in.
1. Click cell G (M908),
2. Click fx, click Match function, click OK,
3. Click the test value,
4. Click cell D (M906),
5. Click the inspection range and specify (K63 to Q63) (drag). Write (K63; Q63).
6. Click the collation type, enter 1, click OK, and get 6.

Next, find the value of cell H (L910) of No. 1 DOT (P). This finds the intersection of Heel's row (cell B) and column (cell F). Use the INDEX function.
1. Click cell H (L910),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. For the array, specify (drag) all the tonnage display parts except the row number and column number. The array is written as K64; Q157, and a wide range is specified.
6. Click the line number,
7. Click cell B (K903),
8. Click the column number,
9. Click cell F (L908), click OK and get -0.05.

Next, find the value of J910 of No.1 DOT (P). The INDEX function is used here as well. The INDEX function is used to find the intersection.
1. Click the number of cells J (M910) you want first.
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument (you don't have to do anything here),
5. For the array, specify all the tonnage display area except the row number and column number (drag), and write the array as K64; Q157.
6. Click the line number,
7. Click cell B (K903),
8. Click the column number,
9. Click cell G (M908),
10. Click OK to get -0.09.

Finally, find Result2 of No.1 DOT (P) and cell K (J910). This is because Heel cell E (1.5 degrees in this case) is between cell H and cell J. This is a proportional distribution and is calculated by the following formula.
Result2 = L910- (L910-M910) * (J906-L906)
Link Result2 to cell (E143) of Tank Condition List.

(4_Trim created by Soft)
Next, find cell B (K174) of Volume Adjusted by Trim of No. 4 DOT (P). First, look at the row in cell B (K174). Use the Match function.
Click cell B (K174), click fx, click Match, click OK, click inspection value, click cell A (J174), click inspection range, specify cells A932 to ~ A1109 (A932; A1109) Drag, click match type, enter 1, click OK, get 23. Q117 (1.40 in this case) on page 4 is linked to cell C (J177) of Trim.

Next, find the number before Trim of No.4 DOT (P). Use the HLOOKUP function.
Click cell D (L177), click fx, click HLOOKUP, click OK, click search value, click cell C (J177), click range, specify from cell (B931) to cell (H931) (Drag), click the line number, enter 1, click the search method, enter 1, click OK, get 1.

Next, find the number after Trim of No. 4 DOT (P). Also use the HLOOKUP function.
Click cell E (M177), click fx, click HLOOKUP, click OK, click search value, click cell C (J177), click range, from cell ((B931) to ~ cell (H931), Specify (drag). Click the line number, enter 1, click the search method, enter 1, add +1 to the formula to the right of the function symbol fx. Get 2.
Next, find cell F of No.4 DOT (P). Find the column in which the previous number 1 is.
Use the Match function. Click cell F (L179), click fx, click Match,
Click OK, click the inspection value, click cell D (L177), click the inspection range, and specify (drag) B931; H931 (from B931 to H931). Click the collation type, enter 1, click OK, get 3.

Next, the cell G of No. 4 DOT (P) is obtained. Also use the Match function.
Click cell G (M179). Click fx, click Match, click OK, click the inspection value, click cell E (M177), click the inspection range, and specify (drag) from cell (B931) to cell (H931). Click the collation type, enter 1, click OK, get 4.

Next, find cell J (L181) of No.4 DOT (P). Use the INDEX function. Find the intersection of rows and columns. Use the INDEX function to find the intersection.
Click cell J (L181), click fx, click INDEX, click OK, click OK to select arguments, click array, specify (drag) B932; H1109 (from B932 to H1109), row number Click, click cell B (K174), click column number, click cell F (L179), click OK, get 5.57.

Next, find cell K of (No.4 DOT (P). Similarly, use the INDEX function.
Click cell K (M181), click fx, click INDEX, click OK, click OK to select arguments, click array, B932; H1109B) 932 to ~ H1109) Specify (drag), specify row number Click, click cell B (K174), click column number, click cell G (M179), click OK, get 4.91.

Next, find Result4 of No.4 DOT (P). Cell H (J181) (Page 72). Find the value (1.40) at the midpoint between cell J (L181) and cell K (M181). Calculate the formula below. Put * between () and (). (* Mark means multiplication)
Result4 = L181- (L181-M181) * (J177-L177)
Result4 is linked to cell (D145) of Tank Condition List.

(5_Heel created by Soft)
See No.4 DOT (P) Heel Correction Table. First find the row in cell A (K1070). Use the Match function.
Click cell A (K1070), click fx, click Match, click OK, click inspection value, click cell K (J1070), click inspection range, click J188; J224 (J188 to J224), Specify (drag), click the collation type, enter 1, get 5.

Next, find the number before Heel Correction of No. 4 DOT (P). Use the HLOOKUP function.
Click cell C (L1073), click fx, click HLOOKUP, click OK, click search value, click cell B (J1073), click range, K187; Q187 (from K187 to Q187) specified (drag) ), Click the line number and enter 1. Click the search method and enter 1. Get one.

Find the number after Heel Correction of No.4 DOT (P). Use the HLOOKUP function.
Click cell D (M1073), click fx Click HLOOKUP, click OK, click search value, click cell B (J1073), click range, K187; Q187, specify (from K187 to Q187) (drag) , Click the line number, enter 1, click the search method, set it to 1, add +1 to the formula on the right of fx, and get 2.

Next, find the number of columns in the previous number of HeelCorrection of No.4 DOT (P). Use the Match function.
Click cell E (L1075), click fx, click Match, click OK, click inspection value, click cell C (L1073), click inspection range, specify K187; Q187, (from K187 to Q187) (Drag), click the type of match, put 1, get 5.

Next, find the number of columns of the number after HeelCorrection of No.4 DOT (P). Use the Match function.
Click cell F (M1075), click fx, click Match, click OK, click inspection value, click cell D (M1073), click inspection range, specify K187; Q187, (from K187 to Q187) (Drag), click the type of collation, enter 1, OK, get 6.

Next, find the intersection of the number of rows and columns before No. 4 DOT (P). Use the INDEX function.
Click cell G (L1077), click fx, click INDEX, click OK, click OK to select arguments, click array, (K188; Q224), specify (drag) from K188 to ~ Q224, row Click the number, click cell A (K1070), click the column number, click cell E (L1075), click OK, get -1.14.

Next, find the intersection of the number of rows and columns after No. 4 DOT (P). Use the INDEX function.
Click cell H (M1077), click fx, click INDEX, click OK, click OK to select arguments, click array, K188; Q224, specify (drag) (from K188 to Q224), select row Click, click cell A (K1070), click column, click cell F (M1075), click OK, get -2.06.

Next, from No. 4 DOT (P) cell G and cell H, Result5 is calculated by the following formula.
Result5 = L1077- (L1077-M1077) * (J1073-L1073)
Link Result5 to E145 of Tank Condition List.

(7 Trim created by Soft)
Find row cell A (K231) of Sounding (oil level depth) of No.4 DOT (S). Cell A is Sounding
Find out what row in the Table it is. Use the Match function.
1. Click cell A (K231),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell L (J231)
6. Click the inspection range,
7. A1124; A1302, (A1124 to A1302) designation (drag),
8. Click the collation type, enter 1, click OK, get 34.

Next, the number cells C (L235) before the Trim cell B (J235) of No. 4 DOT (S) are obtained. For the previous number, if the trim is now 1.40, 1 is the previous number and 2 is the later number. Now that you know what the front and back numbers mean, use the HLOOKUP function. Operate in the order of the numbers below.
1. Click cell C (L235),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the inspection value,
5. Click cell B (J235),
6. Click on the range,
7. B1123; H1123 (B1123 to H1123) designation (drag),
8. Click the line number,
9. Put in 1,
10. Click the search method, enter 1 and click OK. Get one.

Next, find Trim of No. 4 DOT (S) and several cells D (M235) after cell B (J235). Also use the HLOOKUP function.
1. Click cell D (M235),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the inspection value,
5. Click cell B (J235),
6. Click on the range,
7. B1123; H1123, (from B1123 to ~ H1123) designation (drag),
8. Click the line number and enter 1.
9. Click the search method,
10. Put 1 and add +1 to the end of the formula to the right of the function symbol fx and click OK to get 2.

Next, find out what column is the number of columns before No4.DOT (S). Examine cell E (L237). Use the Match function.
1. Click cell E (L237),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell C (L235),
6. Click the inspection range,
7. B1123; H1123, (from B1123 to H1123) designation (drag),
8. Click the collation type,
9.1, click OK,
Get 10.3.

Next, check the number after No. 4 DOT (S) and the column in which cell F (M237) is located.
Use the Match function.
1. Click cell F (M237),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (M235),
6. Click the inspection range,
7. B1123; H1123, (from B1123 to ~ H1123) designation (drag),
8. Click the collation type,
9. Enter 1, click OK,
Get 10.4.

Next, find the intersection of the number of columns before No. 4 DOT (S) and the row of Sounding. Use the INDEX function.
1. Click cell J (L239),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. B1124; H1302, (from B1124 to H1302) designation (drag),
7. Click the line number,
8. Click cell A (K231),
9. Click on the column number,
10. Click cell E (L237), click OK,
11. Get 9.17. Check with the Tank Table.

Next, find the intersection of the number column after No. 4 DOT (S) and cell A (K231) in the Sounding row. Also use the INDEX function.
1. Click cell H (M239),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. B1124; H1302, from B1124 to H1302) Designation (drag),
7. Click the line number,
8. Click cell A (K231),
9. Click on the column number,
10. Click cell F (M237) to get 8.44.

Next, calculate Result7 of No.4 DOT (S). Cell K (J239). Calculate with the following formula. Link Result7 to cell D147 on page 3.
Result7 ＝ L239- (L239-M239) * (J235-L235)

(8_Heel created by Soft)
Next, perform Heel Adjust for No. 4 DOT (S). First, the row cell B (K1127) of the cell A (J1127) is obtained. See the Heel Correction Table on page 74. Here, the Match function is used.
1. Click cell B (K1127),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell A (J1127),
6. Click the inspection range,
7. J455; J491, from J455 to ~ J491, specify (drag),
8. Click the collation type,
9. Put in 1, click OK, get 7.

Next, the number cells D (L1130) before the Heel cell C (J1130) of No. 4 DOT (S) are obtained. Use the HLOOKUP function. In this case, since it is tilted 1.5 degrees to starboard, the previous number should be 1.
1. Click cell D (L1130),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J1130),
6. Click on the range,
7. K454; Q454, (from K454 to Q454) designation (drag),
8. Click the line number,
9. Enter 1, click OK,
10. Click the search method, enter 1, click OK, get 1.

Find the number cell E (M1130) after Heel cell C (J1130> of No.4DOT (S). Use the HLOOKUP function. Since Heel is 1.5 degrees (in this case), if it is 2, the answer is correct. be.
1. Click cell E (M1130),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J1130)
6. Click on the range,
7. K454; Q454, (K454 to Q454) Designation (drag)
8. Click the line number,
9. Put in 1,
10. Click the search method,
11. Insert 1 and add +1 to the formula to the right of the function symbol fx. Get 2.

Next, the number of columns before No. 4 DOT (S), cell F (L1132), is obtained. Use the Match function.
1. Click cell F (L1132),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (L1130),
6. Click the inspection range,
7. K454; Q454, (K454 to Q454), designation (drag),
8. Click the collation type,
9. Set to 1, click OK, and get 5.

Next, the number of columns after No. 4 DOT (S), cell G (M1130), is obtained. Use the Match function.
1. Click cell G (M1132),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M1130),
6. Click the inspection range,
7. K454; Q454, (from K454 to Q454) designation (drag),
8. Click the collation type,
9. Enter 1 and click OK,
Get 10.6.

Next, find the intersection of row cell B (K1127) of Sounding of No. 4 DOT (S) and column cell F (L1132) of the previous number. Find the intersection. Use the INDEX function.
Click cell H (L1134), click fx, click INDEX, click OK, click OK for argument selection, click array, K455; Q491, specify (drag) (from K455 to ~ Q491), row number Click, click cell B (K1127), click column number, click cell F (L1132), click OK, get 1.26.

Next, find the intersection of row cell B (K1127) of Sounding of No. 4 DOT (S) and column cell G (M1132) of the later number. Use the INDEX function.
Click cell J (M1134), click fx, click INDEX, click OK, click OK for argument selection, click array, K455; Q491, specify (drag) (from K455 to Q491), row number Click, click cell B (K1127), click column number, click cell G (M1132), click OK, get 2.72.

Next, the Result8 cell K (J1134) of No. 4 DOT (S) is obtained. Calculate with the following formula.
Result8 = L1134- (L1134-M1134) * (J1130-L1130)
Link Result8 to cell E147 of Tank Condition List.
Soft creation 1 to 8 described DO (Diesel Oil) creation software, but from here, FO Soft creation 11 will be described.

(11_Trim created by Soft)
Find row cell B (K511) of Sounding of No.2 FOT (S). Find out what line the cell A (J511) of this Sounding is in from the top. Use the Match function. Operate in the order of the numbers below.
Click cell B (K511), click fx, click Match, click OK, click inspection value, click cell A (J511), click inspection range, specify A1309; A2228, (from A1309 to A2228) (Drag), click match type, enter 1, click OK, get 510.

Next, the number cell D (L514) before Trim of No. 2 FOT (S) is obtained. In this case Trim is 1.40
Therefore, the former number is 1.0 and the latter number is 2.0. Use the HLOOKUP function.
Click the number cell D (L514) before Trim (the number you want to find now), click fx, click HLOOKUP, click OK, click the search value, click cell C (J514), click the range , B1308; H1308, (from B1308 to H1308) Specify (drag), click the line number, enter 1, click the search method, enter 1 and enter 1, then click OK. Get one.

Next, the number cell E (M514) after Trim of No. 2 FOT (S) is obtained. Use the HLOOKUP function.
Click cell E (M514), click fx, click HLOOKUP, click OK Click search value, click cell C (J514), click range, B1308; H1308, specify (from B1308 to H1308) (drag) , Click the line number, enter 1, click the search method, enter 1, add +1 to the formula to the right of fx, click OK, and get 2.

Next, find the number in cell F (L516) of No. 2 FOT (S). This is to find out what column the number before Trim is in. Use the Match function.
1. Click cell F (L516),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (L514),
6. Click the inspection range,
7. B1308; H1308, (from B1308 to H1308) designation (drag),
8. Click the collation type, enter 1, click OK, and get 3.

Next, check the numerical value of cell G (M516) of No. 2 FOT (S). That is, check the number of columns of the previous number.
Use the Match function.
1. Click cell G (M516),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M514),
6. Click the inspection range,
7. B1308; H1308, (from B1308 to H1308) designation (drag),
8. Click the collation type, enter 1, click OK, get 4.

Next, find the value of the intersection of the No. 2 FOT (S) Sounding row and the number of columns before Trim. Use the INDEX function.
1. Click cell H (L518),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. B1309; H2228, (from B1309 to H2228) designation (drag),
7. Click the line number,
8. Click cell B (K511),
9. Click on the column number,
10. Click cell F (L516), click OK, and get 134.00.

Next, find the value of the intersection of the No. 2 FOT (S) Sounding row and the number column after Trim.
Use the INDEX function.
1. Click cell J (M518),
2. Click fx,
3. Click INDEX, click OK
4. Click OK to select the argument,
5. Click on the array,
6. B1309; H2228, (from B1309 to H2228) designation (drag),
7. Click the line number,
8. Click cell B (K511),
9. Click on the column number,
10. Click cell G (M516), click OK and get 133.36.

Next, find Result_11 of No.2 FOT (S). Put the following formula in the cell of Result_11 and calculate.
Result_11 = L518- (L518-M518) * (J514-L514)
This Result_11 is linked to cell D118 on page 3.

(12_Heel created by Soft)
Next, perform No.2 FOT (S) Heel Adjust. Fig. 3 Find the cell (E118) on page 3 of the DVD. Find out what row the row in cell B (K1183) is in. Use the Match function.
1. Click cell B (K1183),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell A (J1183),
6. Click the inspection range,
7. J568; J659, (from J568 to J659) designation (drag)
8. Click the collation type,
9. Enter 1 and click OK to get 51.

Next, find the number before Heel of No. 2 FOT (S). In this case, it should be 1 because it is 1.5 degrees. The number after the next check should be 2. Here we use the HLOOKUP function.
1. Click cell D (L1186),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J1186),
6. Click on the range,
7. K567; Q567, (from K567 to ~ Q567) designation (drag),
8. Click the line number, enter 1, click the search method,
9. Set to 1, click OK, and get 1.

Next, the number cell E (M1186) after the Heel of No. 2 FOT (S) is obtained. Use the HLOOKUP function.
1. Click cell E (M1186),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J1186),
6. Click on the range,
7. K567; Q567, (from K567 to Q567) designation (drag),
8. Click the line number,
9. Put in 1,
Set to 10.1, enter +1 in the formula to the right of the function symbol (fx), click OK, and get 2.

Next, check the column number (number of columns) in front of the No. 2 FOT (S) Heel. Use the Match function.
1. Click cell F (L1188),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (L1186),
6. Click the inspection range,
7. K567; Q567 (K567 to Q567) designation (drag),
8. Click the collation type, enter 1, click OK and get 5.

Next, the number of columns of the number cell G (M1186) after the Heel of No. 2 FOT (S) is obtained. Use the Match function.
1. Click cell G (M1188),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M1186),
6. Click the inspection range,
7. K567; Q567 (K567 to Q567) designation (drag),
8. Click the match type,
9. Put in 1, click OK, get 6.

Next, find the intersection of the No. 2 FOT (S) Sounding row and the column of the number before Heel. Use the INDEX function.
1. Click cell J (L1190),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. K568; Q659 (from K568 to Q659) designation (drag),
7. Click the line number,
8. Click cell B (K1183),
9. Click on the column number,
10. Click cell F (L1188) to get 0.50.

Next, find the intersection of the No. 2 FOT (S) Soundinng row and the number column after Heel. Use the INDEX function.
1. Click cell K (M1190),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. K568; Q659 (K568 to Q659) designation (drag),
7. Click the line number,
8. Click cell B (K1183),
9. Click on the column number,
10. Click cell G (M1188), click OK and get 1.01.

Next, find Result_12 of No.2 FOT (S). Calculate by the following formula.
Result_12 = L1190-(L1190-M1190) * (J1186-L1186)
Result_12 is linked to E118 on page 3 of Fig. 3 DVD.

(14_Trim created by Soft)
Next, find the Sounding line of No.3 FOT (P). Find cell B (K679). Use the Match function.
1. Click cell B (K679),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell A (J679),
6. Click the inspection range,
7. A2244; A2992, (from A2244 to A2992) designation (drag),
8. Click the collation type,
9. Put in 1, click OK, get 24.

Next, find the number before Trim of No.3 FOT (P). Find cell D (L681). Use the HLOOKUP function.
1. Click cell D (L681),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J682),
6. Click on the range,
7. B2243; H2243, (from B2243 to H2243) designation (drag),
8. Click the search method,
9. Enter 1 and click OK to get 1.

Next, find the number after Trim of No.3 FOT (P). Use the HLOOKUP function.
1. Click cell E (M681),
2. Click fx,
3. Click HLOOKUP,
4. Click the search value,
5. Click cell C (J682),
6. Click on the range,
7. B2243; H2243, (from B2243 to H2243) designation (drag),
8. Click the line number,
9. Put 1 and add +1 to the formula to the right of fx, click OK and get 2.

Next, check the number of columns in front of No.3 FOT (P) Trim. Find out what column the previous number is in. Use the Match function.
1. Click cell F (L683),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (L681),
6. Click the inspection range,
7. B2243; H2243, (from B2243 to H2243) designation (drag),
8. Click the collation type,
9. Put in 1, click OK, get 3.

Next, check the number of columns after No.3 FOT (P) Trim. Find out what column the latter number is in. Use the Match function.
1. Click cell G (M683),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M681),
6. Click the inspection range,
7. B2243; H2243, (from B2243 to H2243) designation (drag),
8. Click the collation type,
9. Put in 1, click OK, get 4.

Next, find the value of the intersection of the Sounding row of No. 3 FOT (P) and the column of the number before Trim. Use the INDEX function.
1. Click cell J (L685),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. B2244; H2992, (from B2244 to ~ H2992) designation (drag),
7. Click the line number,
8. Click cell B (K679),
9. Click on the column number,
10. Click cell F (L683), click OK and get 4.39.

Next, find the value of the intersection of the No. 3 FOT (P) Sounding row and the number column after Trim. Use the INDEX function.
1. Click cell K (M685),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. B2244; H2992, (B2244 to H2992) designation (drag),
7. Click the line number,
8. Click cell B (K679),
9. Click on the column number,
10. Click cell G (M683), click OK and get 4.91.

Next, find Result_14 of No.3 FOT (P). Calculate with the following formula
Result_14 = L685- (L685-M685) * (J682-L681)
Link Result_14 to cell D120 of Tank Condition List.

(15_Heel created by Soft)
Next, perform No.3 FOT (P) Heel Adjust. Of course, if the ship is tilted, it must be adjusted. Find the adjustment value. First, find the Sounding row in the HeelCorrectionTable. Use the Match function.
1. Click cell B (K1239),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell A (J1239),
6. Click the inspection range,
7. J694; J769, (from J694 to ~ J769) designation (drag)
8. Click the collation type,
9. Put in 1, click OK, get 3.

Next, find the number before Heel of No.3 FOT (P). Heel is 1.5 degrees (in this case), so if it becomes 1, it is OK. Use the HLOOKUP function.
1. Click cell D (L1242),
2. Click fx,
3. Click HLOOKUP, click OK,
4. Click the search value,
5. Click cell C (J1242),
6. Click on the range,
7. K693; Q693, (K693 to Q693) designation (drag),
8. Click the line number, enter 1,
9. Click the search method, enter 1 and click OK to get 1.

Next, find the number after Heel Adjust of No. 3 FOT (P). The correct answer for the latter number is 2.
Use the HLOOKUP function.
1. Click cell E (M1242),
2. Click fx,
3. Click HLOOKUP,
4. Click the search value,
5. Click cell C (J1242),
6. Click on the range,
7. K693; Q693, (K693 to Q693) specified (drag)
8. Click the line number, enter 1,
9. Click the search method, enter 1, add +1 to the formula to the right of fx, click OK, and get 2.

Next, find the number of columns in front of the No. 3 FOT (P) Heel. Find out what column the previous number is in. Use the Match function.
1. Click cell F (L1244),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell D (L1242),
6. Click the inspection range,
7. K693; Q693, (from K693 to Q693) designation (drag),
8. Click the collation type, enter 1, click OK and get 5.

Next, find the number of columns after the No. 3 FOT (P) Heel. Find out what column the latter number is in. Use the Match function. Operate in the order of the numbers below.
1. Click cell G (M1244),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell E (M1242),
6. Click the inspection range,
7. K693; Q693, (K693 to Q693) designation (drag),
8. Click the collation type,
9. Put in 1, click OK, get 6.

Next, find the intersection of the No. 3 FOT (P) Sounding row and the column of the number before Heel. Use the INDEX function.
1. Click cell J (L1246),
2. Click fx,
3. Click INDEX, click OK,
4. Click OK to select the argument,
5. Click on the array,
6. K694; Q769, (K694 to Q769) designation (drag),
7. Click the line number,
8. Click cell B (K1239),
9. Click on the column number,
10. Click cell F (L1244), click OK and get 0.28.

Next, find the intersection of the No. 3 FOT (P) Sounding row and the number column after Heel. Use the INDEX function.
1. Click cell K (M1246),
2. Click fx,
3. Click INDEX,
4. Click OK to select the argument,
5. Click on the array,
6. K694; Q769, (K694 to Q769) designation (drag),
7. Click the line number,
8. Click cell B (K1239),
9. Click on the column number,
10. Click cell G (M1244), click OK and get 0.58.

Next, find Result_15 of No3FOT (P). Calculate by the following formula.
Result_15 = L1246- (L1246-M1246) * (J1242-L1242)
Result_15 is linked to E120 in Fig. 3.

(17_Trim created by Soft)
Next, find the Sounding line of Volume Adjusted by Trim of No.3 FOT (S). Use the Match function.
1. Click cell B (K776),
2. Click fx,
3. Click Match, click OK,
4. Click the inspection value,
5. Click cell A (J776),
6. Click the inspection range
7. A2244; A2992, (from A2244 to A2992) designation (drag),
8. Click the collation type,
9. Put in 1, click OK, get 39.

Next, find the number before Trim of No.3 FOT (S). In this case, since it is 1.40m, 1m is the previous number. The latter number will be 2m. Use the HLOOKUP function.
Click cell D (L779), click fx, click HLOOKUP, click OK,
Click the search value, click cell C (J779), click the range, specify (drag) B2243; H2243 (from B2243 to H2243), click the row number, enter 1, click OK, get 1.

Next, find the number after Trim of No.3 FOT (S). Use the HLOOKUP function. I think you already know the meaning of the numbers before and after.
Click cell E (M779), click fx, click HLOOKUP, click OK, click search value, click cell C (J779), lick range, B2243; H2243, specify (from B2243 to H2243) ( Drag), click the line number, enter 1, click the search method, enter 1, add +1 to the end of the expression to the right of the function symbol fx, click OK, get 2.

Next, check the column of the number before Trim of No.3 FOT (S). Check the number of columns of 1 (in this case). Use the Match function.
Click cell F (L781), click fx, click Match, click OK, click inspection value, click cell D (L779), click inspection range, specify B2243; H2243, (from B2243 to H22343) (Drag), click the type of match, enter 1, click OK, get 3.

Next, examine the number column after Trim of No.3 FOT (S). Find out what column the latter number is in. The Match function is used here as well.
Click cell G (M781), click fx, click Match, click OK, click inspection value, click cell E (M779), click inspection range, B2243; H2243, specify (from B2243 to H2243) (Drag), click the collation type, enter 1, click OK, get 4.

Next, check the intersection of the Sounding row of No. 3 FOT (S) and the column of the number before Trim. Use the INDEX function.
Click cell J (L783), click fx, click INDEX, click OK, click OK for argument selection, click array, specify (drag) B2244; H2992 (from B2244 to H2992), specify the row number Click, click cell B (K776), click column number, click cell F (L781), click OK, get 6.87.

Next, the intersection of the No. 3 FOT (S) Sounding row and the number column after Trim is examined. Use the INDEX function.
Click cell K (M783), click fx, click INDEX, click OK, click OK for argument selection, click array, specify (drag) B2244; H2992 (from B2244 to H2992), specify row number Click, click cell B (K776), click column number, click cell G (M781), click OK, get 7.43.

Next, find Result_17 of No.3 FOT (S). Calculate with the following formula.
Result_17 = L783- (L783-M783) * (J779-L779)
Result_17 is linked to D122 in FIG.

(18_Heel created by Soft)
Next, perform No.3 FOT (S) Heel Adjust. Since the ship is tilted, consider what kind of adjustment should be made to make it horizontal. Examine the Sounding line. Find out what line the Sounding number is on. Use the Match function.
Click cell B (K1351), click fx, click Match, click OK, click inspection value, click cell A (J1351), click inspection range, specify J794; J869 (from J794 to J869) (from J794 to J869) Drag), click the match type, enter 1, click OK, get 4.

Next, check the number before Heel of No.3 FOT (S). Use the HLOOKUP function.
Operate in the order of the numbers below.
Click cell D (L1354) fx, click HLOOKUP, click OK, click search value, click cell C (J1354), click range, specify (drag) K793; Q793 (from K793 to Q793), row Click the number, enter 1, click the search method, enter 1, get 1.

Next, check the number after Heel of No.3 FOT (S). Use the HLOOKUP function.
Click cell E (M1354), click fx, click search value, click cell C (J1354), click range, specify (drag) K793; Q793 (from K793 to Q793), click row number, 1 Enter, click the search method, enter 1, add +1 to the end of the function expression, click OK, get 2.

Next, adjust the Heel of No.3 FOT (S). Examine the number column before Heel. Use the Match function.
Click cell F (L1356), click fx, click Match, click OK, click inspection value, click cell D (L1354), click inspection range, K793; Q793 (from K793 to Q793) specified ( Drag), click match type, click 1, click OK, get 5, the number 1 before Heel indicates that it is in the 5th column.

Next, check the number column after Heel of No.3 FOT (S). Use the Match function.
Click cell G (M1356), click fx, click Match, click the check value, click cell E (M1354). Click the inspection range, specify (drag) K793; Q793 (from K793 to Q793), click the type of collation, enter 1, click OK, and get 6.

Next, find the intersection of the No. 3 FOT (S) Sounding row and the column of the number before Heel. Use the INDEX function.
Click cell J (L1358), fx, click INDEX, click OK, click OK for argument selection, click array K794; Q869 (from K794 to Q869) specify (drag), click row number, cell Click B (K1351), column number, click cell F (L1356), click OK, get -0.31.

Next, find the intersection of the Soungding row of No. 3 FOT (S) and the number column after Heel. Use the INDEX function.
Click cell K (M1358), fx, click INDEX, click OK, click OK for argument selection, click array, specify (drag) K794; Q869 (from K794 to Q869), click row number, Click cell B (K1351), click column number, click cell G (M1356), OK, get -0.62.

Next, the Result_18 of No. 3 FOT (S) is calculated by the following formula.
Result_18 = L1358- (L1358-M1358) * (J1354-L1354)
Result_18 is linked to the cell (E122) of the Tank Condition List in FIG.

Next, how to create a Tank Condition List for After Bunkering will be described. The preparation method is almost the same, but since new oil is loaded on the residual oil, the oil is naturally mixed. Oil with a different temperature will be mixed with oil with a low temperature. Also, the specific density (or Density) changes. Density is used in the outer land, and specific weight is used in Japan. No matter which one you use, you can ignore Bunkering. Since the cell table of AfterBunkering is created on the right side of BeforeBunkering, you can fill in the blank cells (as in the case of BeforeBunkering). Then, consider the calculation of the mixing temperature and the calculation of the mixing specific density.
Since it was explained in detail in Before Bunkering, only the important points will be described, and the method of calculating the mixing temperature and the calculation method of the mixing specific density will be mainly explained.

(22 created by Soft)
No.1DOT (P) Since it is After Bunkering from here, use the lower row in the column to the right of the TANK name in Fig. 3. Enter the known number first. First, ask for Volume Adjusted by Trim. Find one cell in one line below Since we have already explained in Before Bunkering, details are omitted.
(1) Use the Match function to find the Sounding line.
(2) Use the HLOOKUP function to find the number before Trim.
(3) Use the HLOOKUP function to find the number after Trim.
(4) Use the Match function to find the number of columns before Trim.
(5) Use the Match function to find the column of numbers after Trim.
(6) Use the INDEX function to find the intersection of the Sounding row and the number of columns before Trim.
(7) Use the INDEX function to find the intersection of the Sounding row and the number column after Trim.
Result22 is obtained by the following formula. Calculate by putting the following formula in cell V (O15).
Result22 = Q15-(Q15-R15) * (O11-Q11)
Result22 is linked to the cell (D144) in FIG.

(23 created by Soft)
Next, find the adjustment value of Heel after loading new oil into No. 1 DOT (P) (After Bunkering).
(1) Find cell M (P903). Use the Match function to find the Sounding line.
(2) Use the HLOOKUP function to find the number before Heel.
(3) Use the HLOOKUP function to find the number after Heel.
(4) Use the Match function to check the number column before Heel.
(5) Use the Match function to check the number column after Heel.
(6) Use the INDEX function to find the intersection of the Sounding row and the number of columns before Heel.
(7) Use the INDEX function to find the intersection of the Sounding row and the number column after Heel.
Use the formula below and put the formula in the cell of Result23 to calculate.
Result23 = Q910- (Q910-R910) * (O906-Q906)
Result23 is linked to the cell (E144) in FIG.

(24 created by Soft)
Obtain the temperature (Y154) of the mixed oil of No. 1 DOT (P) After Bunkering. Calculate by the following formula.
(Amount loaded up to now X28 ℃) + (Amount loaded from above X34 ℃) = Total tank amount XT ℃
T (℃) = ((F143 * G143) + ((F144-F143) * Y153)) / F144
The above formula is put in the cell (Y154) to calculate, and the result is linked to the cell (G144) of the Tank Condition List in FIG. T (℃) = mixed oil temperature.

(25 created by Soft)
Next, the mixed specific density (Y144) of No. 1 DOT (P) is obtained. Calculate by the following formula.
S / G (25) = ((F143 * I143) + ((F144-F143) * Y143)) / F144
The above formula is put in the cell (Y144), the calculation is performed, and the result is linked to the cell (I144) in FIG.

(27 created by Soft)
Next, find the Volume Adjusted by Trim of No. 4 DOT (P). Find blank cells in the following order.
(1) Find the Sounding line of After Bunkering. Use Match function.
(2) Find the number before Trim of After Bunkering. Use HLOOKUP function.
(3) Find the number after Trim of After Bunkering. Use HLOOKUP function.
(4) Find the column of numbers before Trim. Use Match function.
(5) Find the column of numbers after Trim. Use Match function.
(6) Find the intersection of the Sounding row and the number of columns before Trim. Use INDEX function.
(7) Find the intersection of the Sounding row and the number of columns before Trim. Use INDEX function.
Result27 = Q181- (Q181-R181) * (O177-Q177)
Result27 is linked to the cell (D146) in FIG.

(28 created by Soft)
Next, perform Heel adjust of No.4 DOT (P). Heel adjustment value can be obtained by operating the following 7 items in order.
(1) Find the Sounding line of After Bunkering. Use the Match function.
(2) Find the number before Heel. Use the HLOOKUP function (3) Find the number after Heel. Use the HLOOKUP function.
(4) Find the column of numbers before Heel. Use the Match function.
(5) Find the column of numbers after Heel. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Heel. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Heel. Use the INDEX function.
Result28 = Q1077- (Q1077-R1077) * (O1073-Q1073)
Result28 is linked to the cell (E146) in FIG.
Now calculate the True Volume. This is calculated directly. True Volume is calculated directly.

(29 created by Soft)
Next, the mixed oil temperature (T ° C) (Y155) of No. 4 DOT (P) is calculated by the following formula.
T (29) = ((F145 * G145) + ((F146-F145) * Y153)) / F146
The above formula is put in the cell (Y155), the calculation is performed, and the result is linked to the cell (G146) of the Tank Condition List in FIG.

(30 created by Soft)
Next, the mixed specific density (Y145) of No. 4 DOT (P) is calculated by the following formula.
S / G (30) = ((F145 * I145) + ((F146-F145) * Y143)) / F146
The above formula is put in the cell (Y145), the calculation is performed, and the result is linked to the cell (I146) of the Tank Condition List in FIG.

(32 created by Soft)
Next, find the Volume Adjusted by Trim of No. 4 DOT (S).
Since it is AfterBunkering, I will briefly describe only the important parts. Find in the order of the circled numbers.
(1) Find the Sounding line. Use the Match function.
(2) Find the number before Trim. Use the HLOOKUP function.
(3) Find the number after Trim. Use the HLOOKUP function. Don't forget +1 after the search method.
(4) Find the column of numbers before Trim. Use the Match function.
(5) Find the column of numbers after Trim. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Trim.
Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Trim. Use the INDEX function.
Using the numerical values obtained in (6) and (7), Result32 is calculated using the following formula.
Result32 = Q239- (Q239-R239) * (O235-Q235)
Result32 is linked to cell D148 in FIG.

(33 created by Soft)
Next, the Heel adjustment value (O1134) of No. 4 DOT (S) is obtained.
(1) Find the Sounding line. Use the Match function. Heel's Sounding.
(2) Find the number before Heel. Use the HLOOKUP function.
(3) Find the number after Heel. Use the HLOOKUP function.
Don't forget to enter 1 and +1 in the search method. Finally OK.
(4) Find the column of numbers before Heel. Use the Match function.
(5) Find the column of numbers after Heel. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Heel. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Heel. Use the INDEX function.
Calculate Result33 using the formula below.
Result33 = Q1134- (Q1134-R1134) * (O1130-Q1130)
Result33 is linked to the cell (E148) in FIG.
Now calculate the True Volume. Perform directly on the Tank Condition List.

(34 created by Soft)
Next, the mixed oil temperature (Y156) of No. 4 DOT (S) is calculated by the following formula.
T (34) = ((F147 * G147) + ((F148-F147) * Y153)) / F148
Put the above formula in the cell (Y156) on page 5, calculate it, and link the result to the cell (G148) in FIG.

(35 created by Soft)
Next, the mixed specific density (Y146) of No. 4 DOT (S) is calculated by the following formula.
S / G (34) = ((F147 * I147) + ((F148-F147) * Y143)) / F148
The above formula is put in the cell (Y146), the calculation is performed, and the result is linked to the cell (I148) in FIG.

(37 created by Soft)
Next, find the Volume Adjusted by Trim of No. 2 FOT (S). The number below (7 cell numbers are calculated. From here, it becomes FOT (heavy oil tank). Only the important part is described.
(1) Find the Sounding line. Use the Match function.
(2) Find the number before Trim. Use the HLOOKUP function.
(3) Find the number after Trim. Use the HLOOKUP function.
(4) Enter 1 in the search method and add +1 to the formula on the right of Fx to make it OK.
(5) Find the column of numbers before Trim. Use the Match function.
(6) Find the column of numbers after Trim. Use the Match function.
(7) Find the intersection of the Sounding row and the number of columns before Trim. Use the INDEX function.
(8) Find the intersection of the Sounding row and the number column after Trim. Use the INDEX function.
Result37 is calculated by the following formula.
Result37 = Q518- (Q518-R518) * (O514-Q514)
The value of Result37 is linked to the cell (D119) in FIG.

(38 created by Soft)
Next, find the Heel Adjust (slope adjustment value) of No. 2 FOT (S). Find the number in the cell with the number below. Describe only important matters.
(1) Find the Sounding line. Use the Match function.
(2) Find the number before Heel. Use the HLOOKUP function.
(3) Find the number after Heel. Use the HLOOKUP function.
(4) Enter 1 in the search method, add +1 to the formula on the right of Fx, and click OK.
(5) Find the column of numbers before Heel. Use the Match function.
(6) Find the column of numbers after Heel. Use the Match function.
(7) Find the intersection of the Sounding row and the number of columns before Heel. Use the INDEX function.
(8) Find the intersection of the Sounding row and the number column after Heel. Use the INDEX function.
Calculate by the following formula.
Result38 = Q1190- (Q1190-R1190) * (O1186-Q1186)
The result of Result38 is linked to the cell (E119) in FIG.
TrueVolume = D119 + E119
Also calculate.

(39 created by Soft)
Next, find the mixed oil temperature on page 5 of No. 2 FOT (S). The following formula is put in the cell (Y135) of FIG. 3 for calculation.
T (39) = ((F118 * G118) + ((F119-F118) * Y134)) / F119
T (39) is linked to the cell (G119) in FIG.

(40 created by Soft)
Next, find the mixed density on page 5 of No. 2 FOT (S). Put the following formula in cell (Y123) and calculate.
S / G (40) = ((F118 * I118) + ((F119-F118) * Y122)) / F119
The S / G (40) is linked to the cell (I119) in FIG.

(42 created by Soft)
Next, find the Volume Adjusted by Trim of No.3 FOT (P).
The height of this oil level is assumed to be 85 to 90% and is tentatively added. You can fix it later. Find the cell values in the order of the numbers below.
(1) Find the Sounding line. Use the Match function.
(2) Find the number before Trim. Use the HLOOKUP function.
(3) Find the number after Trim. Use the HLOOKUP function.
Add +1 to the formula on the right of fx and make it OK.
(4) Find the column of numbers before Trim. Use the Match function.
(5) Find the column of numbers after Trim. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Trim. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Trim. Use the INDEX function.
Result42 is calculated by the following formula, and the value of Result42 is linked to the cell (D121).
Result42 = Q686- (Q686-R686) * (O682-Q682)

(43 created by Soft)
Next, find the No. 3 FOT (P) Heel adjust. Find the cell values one by one in the order of the numbers below.
(1) Find the Sounding line. Use the Match function.
(2) Find the number before Heel. Use the HLOOKUP function.
(3) Find the number after Heel. Use the HLOOKUP function.
After entering 1 in the search method, add +1 to the end of the formula on the right of Fx.
(4) Find the column of numbers before Heel. Use the Match function.
(5) Find the column of numbers after Heel. Use the Match function.
(6) Use the .INDEX function to find the intersection of the Sounding row and the number of columns before Heel.
(7) Use the .INDEX function to find the intersection of the Sounding row and the number column after Heel.
Calculate Result43, using the formula below.
Result43 = Q1246- (Q1246-R1246) * (O1242-Q1242)
The value of Result43 is linked to the cell (E121) in FIG.

(44 created by Soft)
Next, find the mixed oil temperature Y136 on page 5 of No. 3 FOT (P).
Put the following formula in Y136 on page 5 to calculate.
T (44) = ((F120 * G120) + ((F121-F120) * Y134)) / F121
T (44) is linked to G121 in FIG.

(45 created by Soft)
Next, find the mixed density Y124 on page 5 of No. 3 FOT (P).
Calculate by putting the following formula in Y124. This result is linked to I121.
S / G (45) = ((F120 * I120) + ((F121-F120) * Y122)) / F121

(47 created by Soft)
Next, find the Volume Adjusted by Trim of No.3 FOT (S).
Find the cell numbers in the following numerical order.
(1) Find out what line Sounding is on. Use the Match function.
(2) Find the number before Trim. Use the HLOOKUP function.
(3) Find the number after Trim. Use the HLOOKUP function.
(4) Find the column of numbers before Trim. Use the Match function.
(5) Find the column of numbers after Trim. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Trim. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Trim. Use the INDEX function.
Calculate using the following formula and link the result to the cell (D123) in FIG.
Result47 = Q783- (Q783-R783) * (O779-Q779)

(48 created by Soft)
Next, find the No. 3 FOT (S) Heel adjust. Find the cell numbers in the order of the numbers below.
After calculating (1) to (7), Calculate Result48.
(1) Find out what line the Sounding (depth) is in. Use the Match function.
(2) Find the number before Heel. In this case, it is 1.5 degrees, so if 1 is the previous number and 2 is the later number, the answer is correct. Use the HLOOKUP function.
(3) Find the number after Heel. Use the HLOOKUP function. Don't forget to add +1 to the end of the expression to the right of fx.
(4) Find the column of numbers before Heel. Use the Match function.
(5) Find the column of numbers after Heel. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before Heel. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after Heel. Use the INDEX function.
Result48 is calculated using the following formula, and the result is linked to E123 in FIG.
Result48 ＝ Q1358- (Q1358-R1358) * (O1354-Q1354)

(49 created by Soft)
Next, find the mixed oil temperature (Y137) on page 5 of No. 3 FOT (S). The following formula is shown on page 5 of Y137.
Put in and calculate. The resulting value is linked to G123 in FIG.
Mixed oil temperature (MixedOilTemp) = ((F122 * G122) + ((F123-F122) * Y134)) / F123

（Soft作成の9_Temp)
No.4DOT(S)の温度―容積換算係数(T-Volume Factor)を求める。図３のセル(H147)に、セルB（B430)の温度の行を調べる。油温がT-Volume Factor表の何行目に有るかを調べるのである。Match関数を使用する。下記番号順に操作する。
（１）セルB（B430）をクリック、
（２）fxをクリック、
（３）Matchをクリック、OKをクリック、
（４）検査値をクリック、
（５）セルA(A430)をクリック、
（６）検査範囲をクリック、
（７）A6;A316,（A6から〜A316まで）指定（ドラッグ）、
（８）照合の種類をクリック、
（９）1を入れる、OKをクリック、109を得る。 (50 created by Soft)
Next, find the mixed density on page 5 of No. 3 FOT (S). Calculate by putting the following formula in Y125.
Mixed specific gravity (MixedS / G) = (((F122 * I112) + ((F123-F122) * Y122)) / F123
This result is linked to the cell (I123) of FIG.

(Soft created 9_Temp)
No.4 Obtain the temperature-volume conversion factor (T-Volume Factor) of DOT (S). In cell (H147) of FIG. 3, check the temperature row of cell B (B430). Find out in what row of the T-Volume Factor table the oil temperature is. Use the Match function. Operate in the order of the numbers below.
(1) Click cell B (B430),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A430),
(6) Click the inspection range,
(7) A6; A316, (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 109.

Next, the numerical value of several cells C (C433) before the S / G of No. 4 DOT (S) is obtained.
Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell C (C433),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell J (A433),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method, enter 1, click OK, and get 0.8800.

Next, the number cells D (D433) after No. 4 DOT (S) are obtained.
Also use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell D (D433),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell J (A433),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number, enter 1 and
(9) Click the search method, enter 1, add 0.005 to the formula on the right of Fx, and click OK.
(10) Obtain 0.8850.

Next, find the number of columns in which the number before the S / G of No. 4 DOT (S) is in what column.
Use the Match function. Operate in the order of the numbers below.
(1) Click the cell E (C435) of the number to be calculated first,
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell C (C433),
(6) Click the inspection range,
(7) BA; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Insert 1
(10) Get 17.

Next, find the number of columns in which the number after the S / G of No. 4 DOT (S) is.
Use the Match function.
(1) Click cell F (D435),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (D433) (6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Set to 1, click OK, and get 18.

Next, find the intersection of the No. 4 DOT (S) temperature row and the column of the number before the S / G.
Use the INDEX function. Operate in the order of the numbers below.
(1) Click the desired cell G (C437).
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) specified (drag)
(7) Click the line number,
(8) Click cell B (B430),
(9) Click the column number,
(10) Click cell E (C435), click OK, and get 0.9902.

Next, find the intersection of the No. 4 DOT (S) temperature row and the number column after the S / G.
Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell H (D437) of the desired value,
(2) Click fx,
(3) Click INDEX,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, B6 to AP316) Designation (drag),
(7) Click the line number,
(8) Click B (B430),
(9) Click the column number,
(10) Click cell F (D435), click OK, and get 0.9902.

Next, find Result8 of No.4 DOT (S). Calculated by proportional distribution.
Result9 = C437-((C437-D437) * (A433-C433) /0.005)
The numerical value of Result9 is linked to the cell (H147) of the Tank Condition List in FIG.

(10_Temp created by Soft)
Next, find the temperature-volume conversion coefficient of DO Ser.T.
First find the temperature line. Use the Match function. This temperature is checked in which row of the column (temperature) of the temperature-volume conversion coefficient table.
(1) Click cell B (B449) on page 133,
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A449),
(6) Click the inspection range,
(7) A6; A316, (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK.
(10) Obtain 137.

Next, find the few cells D (C452) before the S / G of DOSer.T.
(Previous number) will be explained in detail. Currently the specific density of this tank is 0.8722. This 0.8722 does not exist in the top column of the T-Vulume conversion table. (Here it is Density). Therefore, check this number (before) and (after). Note that the number before the specific density of 0.8722 is 0.8700 and the number after it is 0.8750. This clarified the meaning of the former number and the latter number. Use the HLOOKUP function. Operate in the order of the numbers below.
(Relative density ≒ Dennsity)
(1) Click cell D (C452),
(2) Click fx,
(3) Click HLOOKUP, click OK (4) Click the search value,
(5) Click cell C (A452),
(6) Click the range,
(7) B4; AP4, (B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method, click 1, click OK, and get 0.8700.

Next, find the few cells E (D452) after the S / G of DOSer.T. Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell E (D452),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell C (A452),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number and enter 1
(9) Click the search method, add +0.005 to the formula to the right of the function symbol fx, and click OK.
(10) Obtain 0.8750.

Next, find the column of the number before the S / G of DOSer.T. Use the Match function. Find out in what column (in the T-Volume conversion coefficient table) the previous number (specific gravity = 0.8700 in this case) is. Operate in the order of the symbols below.
(1) Click cell F (C454),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (C452),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 15.

Next, find the column of numbers after the S / G in DOSer.T. Use the Match function (to find out what column the later number of S / Gs are in). Operate in the order of the numbers below.
(1) Click cell G (D454),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell E (D452),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 16.

Next, find the intersection of the temperature row and the specific density (S / G) column of the number before DOSer.T. Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell H (C456),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B449),
(9) Click the column number,
(10) Click cell F (C454), click OK, and get 0.9800.

Next, find the intersection of the temperature row and the specific density (S / G) column of the number after DOSer.T. This intersection is the volume conversion coefficient at this temperature. Operate in the order of the numbers below.
Use the INDEX function.
(1) Click cell J (D456),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B449),
(9) Click the column number,
(10) Click cell G (D454), click OK, and get 0.9802.

Next, find Result10 (cell K) of DOSer.T. This calculates the following formula with proportional distribution.
Ans.10 = C456-((C456-D456) * (A452-C452) /0.005)
This Result10 (0.9801 in this case) is linked to the cell H151 of the Tank Condition List of FIG.

(3_Temp created by Soft)
Although it is in no particular order, there is a cell table in the immediate vicinity for calculating the volume coefficient that changes with temperature, so this will be explained here.
No.1 DOT (P)
First, the temperature and specific density are input to cells A and E from page 4 using the interlocking link method. As explained at Trim, find out what row the temperature A is in the leftmost column of the temperature-volume conversion coefficient table. Use the Match function. Find out what row cell B (B397) is. Operate in the order of the numbers below.
(1) Click cell B (B397),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A397),
(6) Click the inspection range,
(7) A6; A316, (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 (10) Click OK to get 109.
In other words, 28 ° C indicates that it is the 109th line from -25 ° C.

Next, check the number of No. 1 DOT (P) before S / G (specific gravity). In this case, S / G (≈ Density) is 0.8722, so 0.870 is the front number and 0.8750 is the back number in the specific gravity at the top of the temperature-volume conversion coefficient table. Here, the HLOOKUP function is used.
(1) Click cell C (C400), (the cell you are about to find)
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell E (A400) (cell you are about to check)
(6) Click the range,
(7) B4; Specify all AP4 (cells B4 to AP4). Drag.
(8) Search method Click,
(9) Enter 1 and click OK to get 0.870

Next, the number after S / G (specific gravity) of No. 1 DOT (P) is examined. This also uses the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell D (D400),
(2) Click fx,
(3) Click HLOOKUP, click OK ,.
(4) Click OK,
(5) Click the search value,
(6) Click cell E (A400),
(7) Click the range,
(8) (B4; AP4) Specify (drag) (from B4 to AP4),
(9) Click the search method,
(10) Enter 1, add +0.005 to the formula to the right of fx, click OK and get 0.875.

Next, check the value in the column (cell F) of the number before the S / G of No. 1 DOT (P). Use the Match function.
(1) Click cell F (C402),
(2) Click fx,
(3) Click Match,
(4) Click OK,
(5) Click the inspection value,
(6) Click cell C (C400),
(7) Click the inspection range,
(8) B4; AP4 (from B4 to AP4) designation (drag),
(9) Click the type of collation, enter 1,
(10) Click OK to get 15,

Next, the value of the number column (cell G) after No. 1 DOT (P) is obtained. The Match function is used here as well.
(1) Click cell G (D402),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (D400),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Obtain 16 with the type of collation being 1.
S / G (specific gravity) ≒ Density (since it is almost the same, how to use it depends on the location).

Next, the numerical value (Volume Factor of the previous number) of cell H (C405) of No. 1 DOT (P) is obtained. Use the INDEX function. Operate in the following order.
(1) Click cell H (C404),
(2) Click fx,
(3) Click INDEX,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (B6 to AP316), designation (drag),
(7) Click the line number,
(8) Click cell B (B397),
(9) Click the column number,
(10) Click cell F (C402), click OK, and get 0.9900.

Next, the numerical value (Volume Factor of the later number) of cell J (D404) of No. 1 DOT (P) is obtained.
Use the INDEX function.
(1) Click cell J (D404),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B397),
(9) Click the column number,
(10) Click cell G (D402), click OK, and get 0.9901.

上図から、次式が成立する。
(A400-C400):(Y-C404)=(D400-C400):(D404-C404)
(Y-C404)＊(D400-C400)=(A400-C400)＊(D404-C404)
Y=C404-((C404-D404)＊(A400-C400)/(D400-C400))
D400-C400=0.005
Result3=C404-((C404-D404)＊(A400-C400)/0.005)
このResult3を図３のTank Condition ListのH143に連動リンクさせる。
Next, find Result3. As for Result, since SG of cell E is an intermediate value, cell K, which is an intermediate value, is obtained from the following equation. When finding the median, all are proportionally distributed.
Result3 = C404-((C404-D404) * (A400-C400) /0.005)
This Result3 is linked to the cell (H143) of the Tank Condition List of FIG.
Just in case, I will show you how to get the above formula (Result). Draw a simple diagram to explain.

From the above figure, the following equation holds.
(A400-C400): (Y-C404) = (D400-C400): (D404-C404)
(Y-C404) * (D400-C400) = (A400-C400) * (D404-C404)
Y = C404-((C404-D404) * (A400-C400) / (D400-C400))
D400-C400 = 0.005
Result3 = C404-((C404-D404) * (A400-C400) /0.005)
This Result3 is linked to H143 of the Tank Condition List of FIG.

(6_Temp created by Soft)
Next, find the No. 4 DOT (P) temperature-Volume Factor. First find the row in cell B (B413). Use the Match function. Operate in numerical order below.
(1) Click cell B (B413),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A413),
(6) Click the inspection range,
(7) A6; A316 (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 109.

Next, use the .HLOOKUP function to find the number cells C (C416) before the S / G of No. 4 DOT (P). Operate in the order of the numbers below.
(1) Click cell C (C416),
(2) Click fx,
(3) Click HLOOKUP, click OK (4) Click the search value,
(5) Click cell J (A416),
(6) Click the range,
(7) B4; Specify (drag) from AP4, B4 to ~ AP4,
(8) Click the line number and enter 1
(9) Click the search method, enter 1, and get 0.8750.

Next, the number cell D (D416) after the S / G of No. 4 DOT (P) is obtained. Use the HLOOKUP function. Operate in numerical order.
(1) Click cell D (D416),
(2) Click fx (3) Click HLOOKUP,
(4) Click the search value,
(5) Click cell J (A416),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number and enter 1
(9) Click the search method, enter 1, and add +0.005 to the formula on the right of fx. Get 0.8800.

Next, the cell E (C418) of No. 4 DOT (P) is obtained. Find the column in cell C (C418). Use the Match function. Operate in numerical order.
(1) Click cell E (C418),
(2) Click fx (3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell C (C416),
(6) Click the inspection range,
(7) B4; Specify (drag) from AP4, B4 to AP4
(8) Click the type of collation, enter 1, click OK, and get 16.

Next, find the cell F (D418) of No. 4 DOT (P). Find the column of cell D (D416). Use the Match function. Operate in numerical order.
(1) Click cell F (D418),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (D416),
(6) Click the inspection range,
(7) B4; Specify (drag) from AP4, B4 to ~ AP4.
(8) Click the type of collation,
(9) Enter 1 and click OK to get 17.

Next, find cell G (C420) of No. 4 DOT (P). Find the value of the intersection of cell B (B413) and cell E (C418). Use the INDEX function. After that, operate in numerical order.
(1) Click cell G (C420),
(2) Click fx,
(3) Click INDEX, click OK,
(4) OK to select the argument,
(5) Click the array,
(6) B6; AP316, B6 to AP316, designated (drag),
(7) Click the line number,
(8) Click cell B (B413),
(9) Click the column number,
(10) Click cell E (C418), click OK, and get 0.9901.

Next, the cell H (D420) of No. 4 DOT (P) is obtained. This is the intersection of cell B (B413) and cell H (D418). Use the INDEX function. After that, operate in numerical order.
(1) Click cell H (D420),
(2) Click fx,
(3) Click INDEX, click OK,
(4) OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316), designation (drag),
(7) Click the line number,
(8) Click cell B (B413),
(9) Click the column number,
(10) Click cell F (D418), click OK, and get 0.9902.

Next, Result6 of No.4 DOT (P) is obtained. Cell K (A420). Calculated by proportional distribution.
Result6 = C420-((C420-D420) * (A416-C416) /0.005)
Result6 is linked to the cell (H145) of the Tank Condition List in FIG.

(21_Temp created by Soft)
Next, look at the temperature line in FOSer.T. Find out what line the oil temperature is on. Use the Match function. The tank used is No. 2 FOT (S). Operate in the order of the numbers below.
(1) Click cell B (B382),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Cell A (A382)
(6) Click the inspection range,
(7) A6; A316 (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Insert 1
(10) Obtain 221.

Next, check the number before S / G of FOSer.T. Use the HLOOKUP function. In this case, S / G = 0.9791 and the previous number should be 0.9750. Operate in the order of the numbers below.
(1) Click cell D (C384),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell C (A384),
(6) Click the range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Enter 1 and click OK to get 0.975.

Next, check the number after S / G of FOSer.T. Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell E (D384),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell C (A384),
(6) Click the range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Enter 1 and add +0.005 to the formula on the right of fx, click OK and get 0.9800.

Next, check the number of columns before the S / G of FOSer.T. Use the Match function. Operate in the order of the numbers below.
(1) Click cell F (C386),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (C384),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the type of collation, enter 1, click OK, and get 36.

Next, find the number of columns in the number after the S / G of FOSer.T. Use the Match function. Operate in the order of the numbers below (1) Click cell G (D386),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell E (D384),
(6) Click the inspection range,
(7) B4; AP4, from B4 to ~ AP4) Designation (drag),
(8) Click the type of collation, enter 1, click OK, and get 37.

Next, find the intersection of the temperature row of FOSer.T and the column of numbers before the S / G. Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell J (C388),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B382),
(9) Click the column number,
(10) Click cell F (C386),
(11) Enter 1 and click OK to get 0.9563.

Next, find the intersection of the temperature row of FOSer.T and the column of numbers after the S / G. Use the INDEX function.
(1) Click cell K (D388),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B382),
(9) Click the column number,
(10) Click cell G (D386),
(11) Click OK and get 0.9566.

Next, find Result21 of FOSer.T.
Result21 = C388-((C388-D388) * (A384-C384) /0.005)
Result21 is linked to cell H128 in FIG.

(13_Temp created by Soft)
Next, find the No. 2 FOT (S) T-Volume Factor. Since the volume changes depending on the temperature, the volume coefficient at that temperature is obtained. First, the row cell (B325) at temperature A is obtained. Use the Match function. Operate in the order of the numbers below.
(1) Click cell B (B325),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A325),
(6) Click the inspection range,
(7) A6; A316, (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 125.

Next, find the few cells C (C327) before the S / G of No. 2 FOT (S). Here, the HLOOKUP function is used. Operate in the order of the numbers below.
(1) Click cell C (C327),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell E (A327),
(6) Click the range,
(7) B4; AP4, (B4 to AP4) designation (drag)
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Enter 1 and click OK to get 0.9750.

Next, the number cells D (D327) after the S / G of No. 2 FOT (S) are obtained. Find the number of cells D (D327) after S / G. Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell D (D327),
(2) Click fx,
(3) Click HLOOKUP, click OK (4) Click the search value,
(5) Click cell E (A327),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Put 1 and add +0.005 to the right end of the function formula on the right of fx and click OK to get 0.9800.

Next, find the number of columns before the S / G of No. 2 FOT (S). Find cell F (C329). Find out what column the previous number is in. Use the Match function. Operate in the order of the numbers below.
(1) Click cell F (C329),
(2) Click fx.
(3) Click Match,
(4) Click the inspection value,
(5) Click cell C (C327),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Insert 1
(10) Click OK and get 36. In other words, the previous number (specific gravity) indicates that it is in the 36th column.

Next, find the number of columns after the S / G of No. 2 FOT (S). Find cell G (D329). Use the Match function. Check the number of columns in cell D (D327). Operate in the order of the numbers below.
(1) Click cell G (D329),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (D327),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 37.

Next, find the intersection of the No. 2 FOT (S) temperature row and the number column before the S / G. Find cell J (C331). Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell J (C331),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B325),
(9) Click the column number,
(10) Click cell F (C329), click OK, and get 0.9866.

Next, find the intersection of the No. 2 FOT (S) temperature row and the number column after the S / G. Use the INDEX function. Find cell K (D331). Operate in the order of the numbers below.
(1) Click cell K (D331),
(2) Click fx,
(3) Click INDEX,
(4) Click OK to select the argument,
(5) Click the array ,,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B325),
(9) Click the column number,
(10) Click cell G (D329), click OK, and get 0.9867.

Next, find Result13 of No.2 FOT (P). Please calculate by the following formula. Result13 = C331-((C331-D331) * (A327-C327) /0.005)
Result13 is linked to the cell (H118) in FIG.

(16_Temp created by Soft)
Next, the T-Volume Factor (temperature-volume conversion coefficient) of No. 3 FOT (P) is obtained. FIG. 13 is a conversion coefficient table of the temperature-volume conversion coefficient. Find out what line the oil temperature is on. Use the Match function. Operate in the order of the numbers below.
(1) Click cell B (B340),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A340),
(6) Click the inspection range,
(7) A6; A316, (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 109.

Next, check the number before the S / G of No. 3 FOT (P). Since the S / G is 0.9795 (in this case), the number before the S / G is 0.9750 in the S / G row at the top of the T-VFactor table, which corresponds to the previous number. The number after the next appearance is 0.9800. Here, the HLOOKUP function is used. Operate in the order of the numbers below.
(1) Click cell C (C342),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell E (A342),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag)
(8) Click the line number and enter 1
(9) Click the search method,
(10) Enter 1 and click OK to get 0.9750.

Next, check the number after No.3 FOT (P) S / G. Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell D (D342),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell E (A342),
(6) Click the range,
(7) B4; AP4, from B4 to ~ AP4) Designation (drag),
(8) Click the line number, enter 1 (9) Click the search method,
(10) Enter 1, add 0.005 to the formula to the right of fx, click OK and get 0.9800.

Next, find the number of columns before the S / G of No. 3 FOT (P). Find out in what column the number before the S / G is. Use the Match function. Operate in the order of the numbers below.
(1) Click cell F (C344),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell C (C342),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 36.

Next, find the number of columns after the S / G of No. 3 FOT (P). Use the Match function. Operate in the order of the numbers below.
(1) Click cell G (D344),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (D342),
(6) Click the inspection range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 37.

Next, find the numerical value in the column of the number before the S / G of No. 3 FOT (P). Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell J (C346),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B340),
(9) Click the column number,
(10) Click cell F (C344), click OK, and get 0.9913.

Next, find the numerical value in the number column after the S / G of No. 3 FOT (P). Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell K (D346),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, from B6 to ~ AP316) Designation (drag),
(7) Click the line number,
(8) Click cell B (B340),
(9) Click the column number,
(10) Click cell G (D344), click OK, and get 0.9913.

Next, find Result16 of No.3 FOT (P). This number is between the number before and after the S / G. Since the exact value does not come out, it is calculated by proportional distribution.
Result16 ＝ C346-((C346-D346) * (A342-C342) /0.005)
Link cell H (A346) to cell (H120) in Fig. 3.

(19_Temp created by Soft)
Next, find the No. 3 FOT (S) T-Volume Factor. Since the volume changes when the oil temperature changes, the coefficient is calculated so that the volume is 15 ° C. First, check the oil temperature line. Use the Match function. Operate in the order of the numbers below.
(1) Click cell B (B353),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A353),
(6) Click the inspection range,
(7) A6; A316 (from A6 to A316) designation (drag)
(8) Click the type of collation,
(9) Enter 1 and click OK to get 109.

Next, check the number before the S / G of No. 3 FOT (S). In this case, the specific density is 0.9815.
It should be 0.9800. (The latter number will be 0.9850). Use the HLOOKUP function.
Operate in the order of the numbers below.
(1) Click cell D (C356),
(2) Click fx,
(3) Click HLOOKUP,
(4) Click the search value,
(5) Click cell C (A356),
(6) Click the range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the line number (9) Enter 1
(10) Click the search method,
(11) Enter 1 and click OK to get 0.9800.

Next, check the number of No. 3 FOT (S) after S / G. Use the HLOOKUP function. Operate in the order of the numbers below.
(1) Click cell E (D356),
(2) Click fx,
(3) Click HLOOKUP,
(4) Click the search value,
(5) Click cell C (A356),
(6) Click the range,
(7) B4; AP4, (from B4 to AP4) designation (drag),
(8) Click the line number, enter 1 and
(9) Click the search method,
(10) Put 1 and add +0.005 to the formula on the right of fx. Get 0.9850.

Next, check the number of columns before the S / G of No. 3 FOT (S). Use the Match function.
Operate in the order of the numbers below.
(1) Click cell F (C358),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (C356),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the type of collation, enter 1, click OK, and get 37.

Next, check the number of columns after the S / G of No. 3 FOT (S). Use the Match function. Operate in the order of the numbers below.
(1) Click cell G (D358),
(2) Click fx,
(3) Click Match,
(4) Click the inspection value,
(5) Click cell E (D356),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the type of collation, enter 1, click OK, and get 38.

Next, find the intersection of the No. 3 FOT (S) temperature row and the number column before the S / G. Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell J (C360),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (from B6 to AP316) designation (drag)
(7) Click the line number,
(8) Cell B (B353), click (9) Click column number,
(10) Click cell F (C358),
(11) Enter 1 and click OK to get 0.9913.

Next, find the intersection of the No. 3 FOT (S) temperature row and the number column after the S / G. Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell K (D360),
(2) Click fx,
(3) Click INDEX,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316, (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B353),
(9) Click the column number,
(10) Click cell G (D358),
(11) Click OK to get 0.9914.

Next, Result19 of No.3 FOT (S) is calculated using the following formula.
Result19 = C360-((C360-D360) * (A356-C356) /0.005)
Result19 is linked to the cell (H122) of the Tank Condition List of FIG.

Next is 20 created by Soft, but Tank Table does not exist. There is no Correction Table either. Only the T-Volume Factor will be found here. This is because it is a small tank in the engine room. This is because it is not affected by the inclination or trim of the ship.
(20_Temp created by Soft)
Next, the T-Volume Factor (temperature-volume conversion coefficient) of FOSett.T is obtained. First, look at the temperature line. Use the Match function. Use the Match function to find the row. Assuming that you are pulling from No. 2 FOT (S) (in the FO Sett Tank in the engine room), operate in the order of the numbers below.
(1) Click cell B (B368),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell A (A368),
(6) Click the inspection range,
(7) A6; A316 (from A6 to A316) designation (drag),
(8) Click the type of collation,
(9) Enter 1 and click OK to get 183.

Next, find the number before the S / G of FOSett.T. Use the HLOOKUP function. Operate in the order of the numbers below. The HLOOKUP function is used to find the previous number and the latter number.
(1) Click cell D (C370), ← the cell you want to find,
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell C (A370),
(6) Click the range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Click OK and get 0.9750.

Next, find the number after S / G of FOSett.T. Use the HLOOKUP function.
Operate in the order of the numbers below.
(1) Click cell E (D370),
(2) Click fx,
(3) Click HLOOKUP, click OK,
(4) Click the search value,
(5) Click cell C (A370),
(6) Click the range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the line number,
(9) Insert 1
(10) Click the search method,
(11) Enter 1 and add +0.005 to the formula on the right of fx and click OK to get 0.9800.

Next, check the number of columns in the number before the S / G of FOSett.T. Use the Match function. Operate in the order of the numbers below.
(1) Click cell F (C372),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell D (C370),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Insert 1
(10) Click OK and get 36.

Next, look at the number of columns in the number after the S / G in FOSett.T. Use the Match function. Operate in the order of the numbers below.
(1) Click cell G (D372),
(2) Click fx,
(3) Click Match, click OK,
(4) Click the inspection value,
(5) Click cell E (D370),
(6) Click the inspection range,
(7) B4; AP4 (from B4 to AP4) designation (drag),
(8) Click the type of collation,
(9) Insert 1
(10) Click OK and get 37.

Next, find the intersection of the temperature row of FOSett.T and the column of numbers before the S / G.
Use the INDEX function. Operate in the order of the numbers below.
(1) Click cell J (C374),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B368),
(9) Click the column number,
(10) Click cell F (C372),
(11) Click OK to get 0.9684.

Next, find the intersection of the temperature row of FOSett.T and the column of numbers after the S / G. Use the INDEX function. Use the INDEX function to find the intersection. Operate in the order of the numbers below.
(1) Click cell K (D374),
(2) Click fx,
(3) Click INDEX, click OK,
(4) Click OK to select the argument,
(5) Click the array,
(6) B6; AP316 (from B6 to AP316) designation (drag),
(7) Click the line number,
(8) Click cell B (B368),
(9) Click the column number,
(10) Click cell G (D372),
(11) Click OK to get 0.9686.

Next, Result20 of FOSett.T is calculated by the following formula.
Result20 = C374-((C374-D374) * (A370-C370) /0.005)
Result20 is linked to cell H127 in FIG.

(26 created by Soft)
Next, find the TV Factor of After Bunkering of No.1 DOT (P). Here, since the oil is already mixed, the mixed oil temperature and the mixed specific density are used. I have already created a cell table for After Bunkering, so I will use it. Operate in the order of the numbers below.
(1) Find the temperature line using the Match function.
(2) Use the HLOOKUP function to find the number before the specific density.
(3) Use the HLOOKUP function to find the number after the specific density.
Don't forget to add 0.005 to the end of the formula to the right of fx.
(4) Use the Match function to find the sequence of numbers before the specific density.
(5) Use the Match function to find the sequence of numbers after the specific density.
(6) Use the INDEX function to find the intersection of the temperature row and the column of the number before the density.
(7) Use the INDEX function to find the intersection of the temperature row and the column of numbers after the density.
(8) After obtaining the above, calculate by the following formula.
Result26 = H404-((H404-I404) * (F400-H400) /0.005)
Link Result26 to (H144) in Fig. 3. Now that the total tank volume, mixing (TV Factor), and mixing specific density are obtained, the total volume (M / T) of No. 1 DOT (P) can be calculated (multiplied).

(31 created by Soft)
Next, the TV Factor cell (H146) of After Bunkering of No. 4 DOT (P) is obtained. .. Operate in the following order. Use the formula described last. Describe only the important parts.
(1) Find the temperature line using the Match function.
(2) Find the number before S / G. Use the HLOOKUP function.
(3) Find the number after S / G. Use the HLOOKUP function.
When checking the search value, after entering 1 of the search method, do not forget +0.005 in the formula on the right of Fx.
(4) Find the column of numbers before S / G. Use the Match function.
(5) Find the column of numbers after S / G. Use the Match function.
(6) Find the intersection of the temperature row and the column of numbers before the S / G.
(7) Find the intersection of the temperature row and the number column after the S / G.
(8) Result31 is calculated by the following formula.
Result31 = H420-((H420-I420) * (F416-H416) /0.005)
Result31 is linked to the cell (H146) in FIG. With this, the total amount of oil (= remaining amount M / T) of No. 4 DOT (P) can be calculated from the following formula.
Remaining Quantity = F146 * H146 * I146

(36 created by Soft)
Next, the T-Volume Factor of After Bunkering of No. 4 DOT (S) is calculated. Find the values in the order of the numbers below. Find one cell in one row. In the case of Before Bunkering, each operation was explained in detail, but small operations are omitted.
(1) Check the temperature line. Use the Match function.
(2) Check the number before S / G. Use the HLOOKUP function.
(3) Check the number after S / G. Use the HLOOKUP function. Add +0.005 to the formula on the right of fx and make it OK.
(4) Check the column of numbers before S / G. Use the Match function.
(5) Check the number column after S / G. Use the Match function.
(6) Find the intersection of the temperature row and the column of numbers before the S / G. Use the INDEX function.
(7) Find the intersection of the temperature row and the number column after the S / G. Use the INDEX function.
Calculate using the following formula.
Result36 = H437-((H437-I437) * (F433-H433) /0.005)
The result of Result36 is linked to the cell (H148) of FIG. Then, perform (True Volume x TV Factor x S / G) in the Tank Condition List.
This completes all DOT.

(41 created by Soft)
Next, find the mixed TV factor of No. 2 FOT (S) After Bunkering. First, the mixed oil temperature, then the mixed specific density, and the mixed TV Factor are calculated. Obtain each cell value in the order of the numbers below.
(1) Find the temperature line. Use the Match function.
(2) Find the number before S / G. Use the HLOOKUP function.
(3) Find the number after S / G. Use the HLOOKUP function.
Add +0.005 to the formula on the right of fx and make it OK.
(4) Find the column of numbers before S / G. Use the Match function.
(5) Find the column of numbers after S / G. Use the Match function.
(6) Find the intersection of the temperature row and the column of numbers before the S / G. Use the INDEX function.
(7) Find the intersection of the temperature row and the number column after the S / G. Use the INDEX function.
Calculate using the following formula.
Result41 = H331-((H331-I331) * (F327-H327) /0.005)
Result41 is linked to the cell (H119) in FIG. Now that the required values are complete in this column, the Loading Oil (the amount of oil loaded in FIG. 3) is calculated.
Oil load = True Volume X TV Factor (Mixed) XS / G (Mixed)
The above calculation is performed on the Tank Condition List.

(46 created by Soft)
Next, find the T-Volume Factor of After Bunkering of No.3 FOT (P). Find the numbers in the following 7 cells in numerical order. Only important parts will be described.
(1) Find the line of oil temperature. Use the Match function.
(2) Find the number before S / G. Use the HLOOKUP function.
(3) Find the number after S / G. Use the HLOOKUP function. Add +0.005 to the end of the formula on the right of fx to make it OK.
(4) Find the column of numbers before S / G. Use the Match function.
(5) Find the column of numbers after S / G. Use the Match function.
(6) Find the intersection of the Sounding row and the number of columns before the S / G. Use the INDEX function.
(7) Find the intersection of the Sounding row and the number column after the S / G. Use the INDEX function.
Calculate the TV Factor using the formula below. Result46 is linked to the cell (H121) in FIG.
Result46 ＝ H346-((H346-I346) * (F342-H342) /0.005)

(51 created by Soft)
Next, the mixed T-Volume Factor of After Bunkering of No. 3 FOT (S) is obtained. Mixing is not required to determine the T-Volume Factor, but it is included to aid understanding. Obtain the numerical value of each cell in the order of the numbers below.
(1) Check the oil temperature line. Find out what line it is on. Use the Match function.
(2) Find the number before S / G. Use the HLOOKUP function.
(3) Find the number after S / G. Use the HLOOKUP function.
Don't forget to add +0.005 to the formula on the right of fx and make it OK!
(4) Find the column of numbers before S / G. Use the Match function.
(5) Find the column of numbers after S / G. Use the Match function.
(6) Find the intersection of the oil temperature row and the number column before the S / G. Use the INDEX function.
(7) Find the intersection of the oil temperature row and the number column after the S / G. Use the INDEX function.
With this, the numerical values of 7 cells were obtained. Next, Resurt51 is calculated using the following equation.
Result51 = H360-((H360-I360) * (F356-H356) /0.005)
The value of Result51 is linked to the cell (H123) in FIG.
With this, all the cell values of this column {After Bunkering of No. 3 FOT (S) in Fig. 3} were obtained. Calculate the total amount (M / T) in this column. Calculate with the following formula.
Total amount of this tank after loading (M / T) (K123) = F123 * H123 * I123
This calculation is done directly in the cells of the Tank Condition List.
After that, just add, subtract, multiply and divide in the table both vertically and horizontally. As a result, the loaded oil amount (M / T) is calculated by the following formula.
Loading oil amount (M / T) = total amount after loading-total amount before loading

(How to make a Bunkering Plan)
This is how to make a loading plan before loading bunker (oil). This is required before loading (Before Bunkering), during loading, and immediately after loading (after Bunkering). There is time to spare before loading, but there is no time to spare during loading and immediately after the end of Bunkering, and it is necessary to calculate in a short time. We make a plan before loading, but in most cases we do not go according to the plan. Therefore, by utilizing this bunkering support system, it is possible to immediately return to the site and contact the barge (fuel supply company side) and insist that "50 tons are insufficient" or "100 tons are insufficient". Only one port in Japan, the United States, oil-producing countries and Europe can trust the claims of fuel suppliers, but the other countries have little to trust. Shorts of 10 tons and 15 tons are commonplace in the world. Currently, C heavy oil costs 70,000 to 80,000 yen / ton, which is a cost that cannot be overlooked.

Next, the operation method will be described. It is assumed that heavy oil is currently loaded, and that the condition of the After Bunkering tank is 85%. About an hour before Bunkering, open this bunkering support system and re-plan.
1) Adjust the value of Sound. So that No. 2 FOT (S) becomes 85%. Currently 81.5% (this 81.5% is the first Plan and does not appear in this table). Change the Sound. Of cell Y129 in After Bunkering on page 4 from 7.50 to 7.79 so that it is around 87%. Then, the tank volume% becomes approximately 84.7% (≈85%).
2) Next, since No. 3 FOT (P) is 91.6%, change the Sound. Of cell Y130 from 7.00 to 6.37, so that it drops to around 85% (this 91.6% also does not appear in this table). ). Then, the tank capacity% becomes approximately 84.6% (≈85%).
3) Next, No. 3 FOT (S) is 88.3%, which is a little higher, so it is slightly lowered to around 85% (88.3% also does not appear in this table). By changing Sound (6.60) in cell Y131 to → 6.40., It becomes 85.1% (≈85%).

If the volume% of the above three tanks is exactly 85%, if the Sounding value of each tank is shifted by 1 cm, it will be about 85%, but I dare to leave it as it is.
The reason why there is a slight error in 1), 2) and 3) above is that the oil temperature is changed. In this way, change the value of Sound. In the cell table of After Bunkering (page 5) and adjust it so that it becomes the target (volume%) (cells 44, 45, 46). In the case of heavy oil, it is usually measured by Ulrage, so for the final ledge, check the value in cells 44, 45, 46. If you enter the value of Sound. (Depth) 2-3 times, you can get the desired volume%.
In other words, if you change the Sound. Of After Bunkering, the rest will change automatically. It suffices if this final ledge is almost the same as the planned ledge. An error of about 1 to 2 cm is not a problem. DO (Diesel Oil) can calculate the volume% by directly inserting Sound (depth = height of liquid level). In the case of DO stacking, it is usually measured by Sound without using Ulrage. This is because the oil is clean and silky.

1 tanker 2 bridge
10 Computer with monitor 11 Keyboard 12 Monitor 13 Book (tank table)
30 Data input unit 31 Tank table data 32 Calculation unit 33 Result output unit

Claims (1)

A bunkering support system that supports the fuel loading work of ships (hereinafter referred to as bunkering).
A tank table the ship unique fuel tank design values have been described,
A bunkering calculation program that is installed in the computer and calculates various data required for bunkering,
Have,
The bunkering calculation program, the value of the tank table, and it visible table data display unit to which the values of the table data the computer uses to compute match,
Oil temperature, specific gravity, can enter the data input unit to a table to ship舶data inclined state of the ship,
A result output unit that visually displays the calculation results of the bunkering calculation program,
Bunkering support system characterized by being equipped with.

Images