Create some pivot tables and graphical illustrations, for example by TUG CLASS, Fuel Oil Consumed, Lube Oil Consumed

- - TUG CODE - - 7 - - - - - 7 - - - - - - - - - - - - - - - TUG NAME 05 FRANCESE. HADEN 07 PHILIP K 08 C.R. HADEN 11 MARK K 14 ANDREW K 15 HARRIS II 18 HADEN II 17 MATTHEW K 18 WILLIAM M 19 WESLEY A 20 LEXIE M 23 THE JUDGE 28 CLAXTON 27 JESS NEWTON 28 THOR 29 EVELENA 36 LAMAR 43 MARS 44 JUNO 46 JUPITER 47 ATLAS 50 CAPTAIN W.D. HADEN 52 THE DEACON 57 HUNTER M 58 AUDREY 59 DENIA GO CHLOE K 61 ZEUS 63 TRITON 64 H DOUGLAS M 65 NEPTUNE 65 ZYANA K 6/ DAVID B 68 OCEANUS 69 LAURA B 70 POSEIDON 71 EXPORTER 72 JUDY MORAN 73 MARK E. KUEBLER 74 TED C. LITTON 75 CONNOLLY M 76 APOLLO 77 COOPER K 78 MAZU 79 CECIL M 60 GEMINI TUG CLASS BLUDWORTH TOOD TODD MARK K MAIN IRON G1 MAIN IRON G2 MAIN IRON G2 MAIN IRON Z WILLIAM Z-TECH 30-75 Z-TECH 30-75 TODD MAIN IRON G2 MAIN IRON Z Z-TECH 30-75 Z-TECH 30-75 Z-TECH 30-75 BLUDWORTH TODD MAIN IRON G1 MAIN IRON G2 CAPTAIN MAIN IRON G1 Z-TECH 30-75 AUDREY DENIA Z-TECH 24-60 G1 Z-TECH 24-60 G1 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 Z-TECH 24-60 G2 WD 93 WD 93 Z-TECH 30-80 G1. Z-TECH 30-80 G1 Z-TECH 30-80 G1 Z-TECH 30-80 G1 Z-TECH 30-80 G1 Z-TECH 30-80 Z-TECH 30-80 Z-TECH 30-80 MONTHLY TUG F/L CONSUMPTION REPORT (APRIL 2022) PORT STBO MTD MTD MTD LUBE OL LUBE YID F/O MTD TOTAL TOTAL MID FO MIDEO FUEL MIDFO LUBE ENGINE ENGINE RECO REC'D OIL GALS OIL HRS (LOCS) (ACTUAL) USED PER HR REC'D YID FIO GALS VID FIO RECD REC'D USED PER HR YTD HRS (LOCS) (ACTUAL) OIL USED 534 26,000 26,000 10,540 HRS 12,240 23,486 23,486 15,502 30,935 30,935 - 38 18 15,502 8.132 34 0:16 33,502 33,502 30,989 16.882 16,882 - 4,417 3 20,979 416 416 13,000 6,379 11,285 11,000 - 13,000 13.000 16,757 38,000 30,000 42,493 13,000 12,924 35.51 11,000 11,024 36.38 10,000 12,389 37.48 12,000 5,568 50.60 0.12 48,500 40,500 39,695 34,000 34.000 0.25 30,815 15,985 15,985 10,000 13,768 13,768 12,000 7,426 7,426 12,223 17,000 17,313 12,224 1.24 71,833 17,000 16,000 20,261 62.92 17,493 61.81 4,096 4.086 16,000 0.04 54,245 18,582 18,582 8,000 7,376 7,139 7,139 1,380 30.00 21,000 39.689 15,000 15,000 77,296 77.296 47,000 47,000 8,000 21,000 47,000 47,000 29,486 29,486 76.000 76,000 37,433 37,433 10,000 10,236 0.14 52,853 10,236 20,000 11,221 10,000 11,219 0.16 38,463 5,518 1,496 14,000 0.08 78,806 4,563 0.32 16,671 2,109 7,433 5,000 20,000 14,853 35.11 10,000 15,566 55.00 14,000 8,920 59.87 7,433 5,976 59.17 5,000 3,720 16.32 6,896 36.88 12,000 10,931 39.62 13,000 13,137 34.90 20,022 0.07 10,000 10,995 25,679 0.06 19,590 19,590 11,085 25,679 5,193 12,000 5,198 28,000 26,254 28,000 38,000 38,000 0.13 37,801 385 17,381 17,381 13,000 2,174 2,174 13,100 13,100 28,751 0.10 28,000 28,000 21,115 0.26 29,838 29,838 27,699 0.03 14,801 14,801 15,306 20,000 14,100 37.50 7,131 7,088 70.88 14,892 11,478 14.15 12,000 3,745 18.61 10,000 11,799 41.11 16,000 10,949 48.45 29,001 29,001 29,536 0.20 16,000 16,000 13,930 0.07 48,677 39,488 6,406 37.03 0.09 384 3,973 3,973 20,000 100 2,503 2,503 7,131 260 6,085 6,085 14,892 77 23,066 23,066 12,000 287 20,233 26,226 10,000 226 25,164 25,164 16,000 173 20,414 20,414 252 19,399 19,397 9,500 367 22,032 22,032 13,/50 3/1 21,768 21,768 11,000 382 21,271 21,271 15,000 366 20,778 20,778 20,000 375 20,742 20,742 20,500 241 19.490 19,490 7,438 6,126 6,126 48,677 45,000 45,000 48,500 48,500 43.850 39.481 44,587 9,500 11,0/1 43.25 0.05 37.80 0.99 53,850 54,842 0.08 49,500 49,500 39.27 43.15 13,/50 13,8/1 11,000 14,570 15,000 16,485 20,000 13,884 20,500 17,011 7.438 59.655 50,000 47,657 59.655 61,656 50,000 37.93 0.03 47,413 45.36 0.03 58.000 58,000 58,798 9,527 39.53 0.05 37,323 37,323 41,435 4,766 56.07 0.16 14,932 21,061 85 86 4,913 4,913 7,440 7,440 5,239 60.92 0.22 22,970 280 8,198 8,198 15,000 15,000 64.93 0.09 18,181 16,814 14.932 22,351 22,351 64,015 64,015 49,005 63,002 7,838 63.21 A 49,005 63,002 56 048 55,960 54,948 39,774 7,623 14615 57 31 0.15 9,108 49 77 0 05 36 235 266 7,838 255 7,623 183 7,896 7,896 33,585 33,585 149 7.589 7,589 16,000 16,000 8,763 333 8,311 8,311 14,000 14,000 21,122 338 7,631 7,631 18,400 18 400 19,088 331 6,645 6,645 21,000 21,000 20,337 36 235 61,105 58 81 004 61,105 51.274 63 43 002 73,000 73,000 79,959 0.10 67,200 67,200 68,740 56 47 61.81 011 77,700 77,700 75,589 ****** ***** ************* HRS THIS MONTH 213 - 384 325 330 110 - 322 283 46 423 294 149 101 228 187 276 - 390 - . - - 165 - H 40 27 399 12 - 8 58558. 38 26 8 15 15 15 365 30 12 10 13 14 19 24 37 10 6 5 35 35 ************************** 1,001 814 1,078 1,054 1,300 1.354 1,469 1,193 1,420 1,041 381 369 930 900 940 699 859 1268 1,177 1,268 YTD LUBE YTD FUEL ON VTD LUBE YTD LUBE CALS PER YID FO PER OIL REC'D OIL USED HR 216 206 0.39 HR 1974 4043 35.34 146 0 19 381 3.05 . 37.91 37.21 39.11 76 0.07 175 0.17 107 0.15 167 0.40 533 0.43 43.20 41.72 57.98 57.04 38.42 37.42 151 0.16 102 0.53 128 0.12 36.70 188 0.13 59.82 174 0.27 64.96 185 0.15 57.89 56 0.19 17.38 119 0.19 35.53 68 0.22 41.54 96 0.15 36.25 180 0.17 39.88 116 0.16 39.54 38 0.07 67.87 167 0.11 13.69 292 0.28 48.58 127 0.21 143 0.14 43.89 48.51 36.62 39 0.05 51 0.05 42.26 60 0.06 440 0.34 42.19 35.20 41.98 80 0.05 39.74 48 0.04 41.41 56 0.04 39.80 40 0.04 55.28 59 0.15 62.25 47 0.13 60 27 010 62 18 0.01 58.46 0 10 56 83 005 59 69 014 62 08 003 58 40 0.08 5971 0.10 ************** 600 330 220 107 220 110 - 270 525 350 461 291 300 385 165 94 10 93 45 118 40 90 130