Heating_Oil_Deliveries_RAFL_RAFF_FY2016.xlsx

XLSX spreadsheet 694 KB Posted

Attached to
UK Fuel Tank Management and Inspection
Solicitation number
FA5587-18-Q-0024
Issued by

About this file

FY16

View the file

Other files

File Type Posted
Attachment_1_-_Performance_Work_Statement.pdf PDF
FA5587-18-Q-0024_Amendment_00002.pdf PDF
FA5587-18-Q-0024_Amendment_00001.pdf PDF
Q&A_1.pdf PDF
Heating_Oil_Deliveries_RAFL_RAFF_FY2014.xlsx XLSX spreadsheet
Heating_Oil_Deliveries_RAFL_RAFF_FY2015.xlsx XLSX spreadsheet
Attachment_3_-_Tank_Inventory_List.xlsx XLSX spreadsheet
Attachment_2_-_Pricing_Schedule.xlsx XLSX spreadsheet
Attachment_1_-_Performance_Work_Statement.pdf PDF
FA558718Q0024.pdf PDF

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

FY16Total

Oct-15Nov-15Dec-15Jan-16Feb-16Mar-16Apr-16May-16Jun-16Jul-16Aug-16Sep-16Grand Totals FY16
VOPAK/Billed U.S. Gallons for the Month37,774168,273192,915320,872239,100298,628258,132178,27971,2919,51419,45323,6371,817,868

FY16 Building Totals

YEARConversion factor for fuel at local weather factors
FY16Literx0.264301=U.S. Gallons
Total Month Liters for the Building/TankTotal Month U.S. Gallons for the Building/Tank
# Fills in FY16
BLDG. #1728,5007,5336
39502,133132,71435
52278,88773,71019
53000
65165,90043,84827
73112,48429,73017
8011,3993,0136
9439,50310,4418
129000
176000
190000
191000
192000
193000
195000
196000
197000
198000
199000
200000
201000
20240,00310,5732
203000
20424,9956,6061
205000
206000
207000
208000
209000
210000
211000
215000
216000
217000
218000
219000
220000
221000
222000
223000
224000
225000
226000
249000
310000
311000
312000
313000
314000
315000
316000
317000
318000
319000
320000
321000
322000
323000
324000
325000
326000
327000
328000
329000
330000
331000
340000
341000
342000
343000
344000
345000
346000
347000
348000
349000
350000
351000
352000
353000
4312,2635981
43931,0088,19513
443000
448000
456000
457000
459000
6082,6376971
614000
636000
640000
641000
650000
651000
65740,85010,7977
65824,0396,3546
6592,9347751
67011,1432,9455
682000
684000
690000
692000
69427,8337,3563
777000
80020,3785,38611
80475,66119,9978
820000
825000
826000
833000
834000
844392,253103,67322
880101,23426,75611
900000
904187,37449,5239
90625,1706,6527
907000
908000
913000
915000
9169,5362,5204
917277,44973,33016
930000
931864,221228,41435
93217,5074,6271
934122,11032,27412
944000
946167,87344,36918
950000
954000
958000
959000
96122,0015,8152
966000
967000
972000
97982,30621,7544
9841,8544901
9894,1241,0902
991000
995000
998 bowser00
10039,4322,4931
1006000
10096,5011,7181
101086,46322,8527
10115,0001,3221
1015000
10173,8391,0152
10197,4291,9633
1027000
103215,2574,0326
103525,2606,6763
1040955,655252,58141
1047000
1065000
10703,6639687
10718,3442,2055
1072000
1073000
10754,7011,2421
1076000
1080000
1081176,16846,56121
10827,4471,9681
108410,8772,8751
1085000
1086000
1087000
1094000
1098000
110028,8527,6262
1102000
1104000
1106000
1107000
110847,41112,5317
1119000
11203,2248522
11255,5561,4683
11272,5176651
11381,6714421
1140000
1146000
1148000
1156000
1165000
120019,6005,1805
1201000
1205000
12102,4236401
1212125,22433,0976
121544,41211,7388
1217000
1219573,872151,67534
122060,57516,0105
12234,2651,1273
1225140,91337,24310
122633,2078,7778
1227000
12343,3648892
1235000
1236000
1239000
1240000
1241000
1243000
1245000
1261000
1263000
1266000
12732,4176393
128072,16819,0748
1281000
1283000
1284000
12864,5581,2052
12888,0002,1141
1290000
12924,2451,1222
1293000
1294000
1295000
130242,09211,1254
1304141,20437,32011
13074,2271,1173
13086,9131,8274
13102,3516213
1311000
13121,5284041
1313000
1314000
13163,1468313
131986,62122,8943
132041,86711,0658
13222,3676261
13244,2331,1193
132510,9732,9005
1326000
13251,8624921
133210,3432,7344
134529,5017,79712
134629,4677,7888
1370000
138434,6209,1503
1385001
1386000
138914,0393,7112
13913,6829736
13925,8661,5503
13952,6026882
13978272191
1417000
1418000
1419000
1439000
1451000
1464000
147362,87216,6174
147629,3487,7573
14921,5704151
14932,3016081
14944,9951,3201
1495000
150915,9044,2036
151117,8514,7184
15225,0711,3402
1549000
1599000
1823000
1827000
1880000
1910000
6001000
6002000
6003000
6004000
6005000
6006000
6007000
6008000
6010000
6011000
6012000
6013000
6014000
6015000
6016000
6017000
6018000
6019000
6020000
6021000
6022000
6023000
6024000
6030000
6031000
6032000
6033000
6034000
6035000
6036000
6037000
6040000
6041000
6042000
6043000
6044000
6045000
6046000
6047000
6048000
6049000
6050000
6051000
6052000
6053000
6054000
6055000
6056000
6057000
6058000
6059000
6170000
6171000
6172000
6173000
6174000
6175000
6180000
6181000
6182000
G0
M0
SG0
0
0
0
00
00
00
Totals =6,852,3151,811,074650

FAC BY MONTH

YEARMONTHRAF Lakenheath (RAFL) and RAF Feltwell (RAFF) Org Code 909 Diesel FuelConversion factor for fuel at local weather factors
Literx0.264301=U.S. Gallons
Tank fill volume in LitersTotal Liters for the Building/TankTotal Month U.S. Gallons for the Building/Tank
OCTNOVDECJANFEBMARAPRMAYJUNEJULYAUGSEPT
BLDG. #17008,0008,0009,0003,50000000028,5007,533
39067,49771,22859,92391,442102,67147,38161,9910000502,133132,714
520037,47128,10968,22248,34829,30150,9887,54104,0004,907278,88773,710
5300000000000000
65025,50030,00126,70123,71030,98223,0066,0000000165,90043,848
73007,00131,99017,99230,00118,5007,0000000112,48429,730
80003,7591,3752,8281,8421,5950000011,3993,013
9407,0005,0007,0005,0006,0009,5030000039,50310,441
12900000000000000
17600000000000000
19000000000000000
19100000000000000
19200000000000000
19300000000000000
19500000000000000
19600000000000000
19700000000000000
19800000000000000
19900000000000000
20000000000000000
20100000000000000
20200040,0030000000040,00310,573
20300000000000000
204000000024,995000024,9956,606
20500000000000000
20600000000000000
20700000000000000
20800000000000000
20900000000000000
21000000000000000
21100000000000000
21500000000000000
21600000000000000
21700000000000000
21800000000000000
21900000000000000
22000000000000000
22100000000000000
22200000000000000
22300000000000000
22400000000000000
22500000000000000
22600000000000000
24900000000000000
31000000000000000
31100000000000000
31200000000000000
31300000000000000
31400000000000000
31500000000000000
31600000000000000
31700000000000000
31800000000000000
31900000000000000
32000000000000000
32100000000000000
32200000000000000
32300000000000000
32400000000000000
32500000000000000
32600000000000000
32700000000000000
32800000000000000
32900000000000000
33000000000000000
33100000000000000
34000000000000000
34100000000000000
34200000000000000
34300000000000000
34400000000000000
34500000000000000
34600000000000000
34700000000000000
34800000000000000
34900000000000000
35000000000000000
35100000000000000
35200000000000000
35300000000000000
4310002,263000000002,263598
43905,73005,4164,6175,6593,5021,5221,85902,703031,0088,195
44300000000000000
44800000000000000
45600000000000000
45700000000000000
45900000000000000
608000000002,6370002,637697
61400000000000000
63600000000000000
64000000000000000
64100000000000000
65000000000000000
65100000000000000
657006,0006,9187,7163,39911,2175,600000040,85010,797
658002,4048,8413,3403,4455,0001,009000024,0396,354
659002,9340000000002,934775
67002,76101,8994,4822,00100000011,1432,945
68200000000000000
68400000000000000
69000000000000000
69200000000000000
69400012,8087,85507,1700000027,8337,356
77700000000000000
8002,07602,0114,7773,6813,8342,23089300087620,3785,386
804007,78120,2409,4706,77710,501020,89200075,66119,997
82000000000000000
82500000000000000
82600000000000000
83300000000000000
83400000000000000
844033,00536,30480,03854,90738,62179,88169,4970000392,253103,673
88008,00019,50025,00110,00015,0489,00014,6850000101,23426,756
90000000000000000
90447,9140028,00117,99621,87549,587022,001000187,37449,523
90603,14004,3985,0054,5966,42201,60900025,1706,652
90700000000000000
90800000000000000
91300000000000000
91500000000000000
916002,54105,27701,718000009,5362,520
91735,50122,00915,00757,60915,42561,67833,74036,4800000277,44973,330
93000000000000000
93130,29892,119117,114138,83661,75572,00489,99237,99774,30935,99654,35059,451864,221228,414
932000000017,507000017,5074,627
9346,70112,88016,95023,35310,33111,63119,002013,50007,7620122,11032,274
94400000000000000
946020,01031,23576,01016,61219,00405,0020000167,87344,369
95000000000000000
95400000000000000
95800000000000000
95900000000000000
9610004,0000018,0010000022,0015,815
96600000000000000
96700000000000000
97200000000000000
97900020,00017,30628,000017,000000082,30621,754
9840001,854000000001,854490
9891,84600002,2780000004,1241,090
99100000000000000
99500000000000000
998 bowser000000000000
10030009,432000000009,4322,493
100600000000000000
1009000000006,5010006,5011,718
101000012,58990930,99625,787016,18200086,46322,852
1011000000005,0000005,0001,322
101500000000000000
101700002,300001,53900003,8391,015
10191,0030001,42605,000000007,4291,963
102700000000000000
103202,16003,3565,0831,83802,820000015,2574,032
1035005,00004,26016,00000000025,2606,676
10400168,926121,562131,022127,515171,581101,994100,50132,554000955,655252,581
104700000000000000
106500000000000000
10705820500075437187658000003,663968
107101,5801,3461,6372,08701,694000008,3442,205
107200000000000000
107300000000000000
107500004,70100000004,7011,242
107600000000000000
108000000000000000
108110,00014,66623,00132,00327,15646,44616,1766,7200000176,16846,561
1082000007,4470000007,4471,968
1084000010,877000000010,8772,875
108500000000000000
108600000000000000
108700000000000000
109400000000000000
109800000000000000
11000000011,6280000017,22428,8527,626
110200000000000000
110400000000000000
110600000000000000
110700000000000000
11080013,4089,0018,00010,001000007,00147,41112,531
111900000000000000
1120009892,235000000003,224852
1125002,0841,665001,807000005,5561,468
1127000002,5170000002,517665
1138000001,6710000001,671442
114000000000000000
114600000000000000
114800000000000000
115600000000000000
116500000000000000
12001,167006,4805,0614,891002,00100019,6005,180
120100000000000000
120500000000000000
1210000002,4230000002,423640
1212011,6019,61120,00036,00018,00030,01200000125,22433,097
121504,3805,0007,57012,1155,0008,6471,700000044,41211,738
121700000000000000
1219091,94526,72085,50644,65091,160122,81190,66720,413000573,872151,675
1220007,50024,83816,90711,33000000060,57516,010
122300962001,598001,7050004,2651,127
1225019,00023,00626,94215,33513,00032,00211,6280000140,91337,243
122606,0005,6965,8646024,5004,3806,165000033,2078,777
122700000000000000
12340001,66401,7000000003,364889
123500000000000000
123600000000000000
123900000000000000
124000000000000000
124100000000000000
124300000000000000
124500000000000000
126100000000000000
126300000000000000
126600000000000000
12730083901,3080027000002,417639
12800017,8528,1835,48220,4967,674012,48100072,16819,074
128100000000000000
128300000000000000
128400000000000000
1286000002,58901,96900004,5581,205
128800008,00000000008,0002,114
129000000000000000
12921,0010003,24400000004,2451,122
129300000000000000
129400000000000000
129500000000000000
1302010,001003,999018,50009,59200042,09211,125
130400050,47631,80829,90014,00315,0170000141,20437,320
130701,5010001,201001,5250004,2271,117
1308002,25102,1851,26101,21600006,9131,827
1310050001002,2010000002,351621
131100000000000000
1312000001,5280000001,528404
131300000000000000
131400000000000000
1316005001,10801,5380000003,146831
13190000026,60360,0180000086,62122,894
1320003,1472,2009915,522030,007000041,86711,065
132200000002,36700002,367626
132401,2691,970994000000004,2331,119
13250002,3861,7924,2672,5280000010,9732,900
132600000000000000
132500001,86200000001,862492
1332003,0902,2732,3172,66300000010,3432,734
13451,91403,6956,3963,0434,6311,4492,1732,31803,882029,5017,797
13463,00104,2053,60907,18202,9447,23801,288029,4677,788
137000000000000000
13840002,37202,244030,004000034,6209,150
138500000000000000
138600000000000000
1389006,132007,90700000014,0393,711
139109695798217540000005593,682973
139202,4121,10802,34600000005,8661,550
13950000001,73586700002,602688
139700000827000000827219
141700000000000000
141800000000000000
141900000000000000
143900000000000000
145100000000000000
146400000000000000
14730014,08017,00016,64215,15000000062,87216,617
147600000029,3480000029,3487,757
14920001,570000000001,570415
14930000002,301000002,301608
1494000004,9950000004,9951,320
149500000000000000
15090002,0275,6035,268003,00600015,9044,203
151100008,40104,27505,17500017,8514,718
15220000003,3241,74700005,0711,340
154900000000000000
159900000000000000
182300000000000000
182700000000000000
188000000000000000
191000000000000000
600100000000000000
600200000000000000
600300000000000000
600400000000000000
600500000000000000
600600000000000000
600700000000000000
600800000000000000
601000000000000000
601100000000000000
601200000000000000
601300000000000000
601400000000000000
601500000000000000
601600000000000000
601700000000000000
601800000000000000
601900000000000000
602000000000000000
602100000000000000
602200000000000000
602300000000000000
602400000000000000
603000000000000000
603100000000000000
603200000000000000
603300000000000000
603400000000000000
603500000000000000
603600000000000000
603700000000000000
604000000000000000
604100000000000000
604200000000000000
604300000000000000
604400000000000000
604500000000000000
604600000000000000
604700000000000000
604800000000000000
604900000000000000
605000000000000000
605100000000000000
605200000000000000
605300000000000000
605400000000000000
605500000000000000
605600000000000000
605700000000000000
605800000000000000
605900000000000000
617000000000000000
617100000000000000
617200000000000000
617300000000000000
617400000000000000
617500000000000000
618000000000000000
618100000000000000
618200000000000000
G000000000000
M000000000000
SG000000000000
00
00
00
Total Liters for the Delivery Date143,004636,111728,0741,208,582899,5841,125,265972,590669,067270,03935,99673,98590,018
Total U.S. Gallons for the Delivery Date37,796168,125192,431319,429237,761297,409257,057176,83571,3729,51419,55423,792
Receipt Value (VOPAK) U.S. Gallons
Difference b/w individual receipts & VOPAK value37,796168,125192,431319,429237,761297,409257,057176,83571,3729,51419,55423,792
Grand Total VOPAK/Billed U.S. Gallons for the Month0LRS: The MONTHS of the FISCAL YEAR are across the top and the buildings are down the side. Go to the date of fill and then type in the liter value from the individual receipt for each building in the purple cells. At the bottom of the spreadsheet, put in the total VOPAK value for that date in the purple cells on the row across the bottom. The rest will automatically calculate.
DLA Price for Fuel this Month $/US Gallon (ensure current)$ 3.16
Total Costs we should expect to see in CRIS$ - 0CE Finance Management: Take the values highlighted in orange from the grand total section and use those for your reports and to compare with CRIS.
Energy Manager: Use the values from the right hand columns to bill customers and to track individual buildings/heat plants

Begin DO NOT DELETE THIS SHEET. NEED THIS SHEET FOR FORMULA ON FY16 BUILDING TOTALS SHEET.

Oct2015

YEARMONTHRAF Lakenheath (RAFL) and RAF Feltwell (RAFF) Org Code 909 Diesel FuelConversion factor for fuel at local weather factors
2015OCTLiterx0.264301=U.S. Gallons
Tank fill volume in LitersDAY OF THE MONTHTotal Month Liters for the Building/TankTotal Month U.S. Gallons for the Building/Tank
12345678910111213141516171819202122232425262728293031
BLDG. #1700
3900
5200
5300
6500
7300
8000
9400
12900
17600
19000
19100
19200
19300
19500
19600
19700
19800
19900
20000
20100
20200
20300
20400
20500
20600
20700
20800
20900
21000
21100
21500
21600
21700
21800
21900
22000
22100
22200
22300
22400
22500
22600
24900
31000
31100
31200
31300
31400
31500
31600
31700
31800
31900
32000
32100
32200
32300
32400
32500
32600
32700
32800
32900
33000
33100
34000
34100
34200
34300
34400
34500
34600
34700
34800
34900
35000
35100
35200
35300
43100
43900
44300
44800
45600
45700
45900
60800
61400
63600
64000
64100
65000
65100
65700
65800
65900
67000
68200
68400
69000
69200
69400
77700
8002,0762,076549
80400
82000
82500
82600
83300
83400
84400
88000
90000
90420,0828,50019,33247,91412,664
90600
90700
90800
91300
91500
91600
91718,99816,50335,5019,383
93000
93111,29519,00330,2988,008
93200
9346,7016,7011,771
94400
94600
95000
95400
95800
95900
96100
96600
96700
97200
97900
98400
9891,8461,846488
99100
99500
998 bowser
100300
100600
100900
101000
101100
101500
101700
10191,0031,003265
102700
103200
103500
104000
104700
106500
1070582582154
107100
107200
107300
107500
107600
108000
108110,00010,0002,643
108200
108400
108500
108600
108700
109400
109800
110000
110200
110400
110600
110700
110800
111900
112000
112500
112700
113800
114000
114600
114800
115600
116500
12001,1671,167308
120100
120500
121000
121200
121500
121700
121900
122000
122300
122500
122600
122700
123400
123500
123600
123900
124000
124100
124300
124500
126100
126300
126600
127300
128000
128100
128300
128400
128600
128800
129000
12921,0011,001265
129300
129400
129500
130200
130400
130700
130800
131000
131100
131200
131300
131400
131600
131900
132000
132200
132400
132500
132600
132500
133200
13451,9141,914506
13463,0013,001793
137000
138400
138500
138600
138900
139100
139200
139500
139700
141700
141800
141900
143900
145100
146400
147300
147600
149200
149300
149400
149500
150900
151100
152200
154900
159900
182300
182700
188000
191000
600100
600200
600300
600400
600500
600600
600700
600800
601000
601100
601200
601300
601400
601500
601600
601700
601800
601900
602000
602100
602200
602300
602400
603000
603100
603200
603300
603400
603500
603600
603700
604000
604100
604200
604300
604400
604500
604600
604700
604800
604900
605000
605100
605200
605300
605400
605500
605600
605700
605800
605900
617000
617100
617200
617300
617400
617500
618000
618100
618200
G
M
SG
00
00
00
Total Liters for the Delivery Date00000000000000030,0000019,0030024,99700018,99825,00325,003000
Total U.S. Gallons for the Delivery Date0000000000000007,929005,023006,6070005,0216,6086,608000
Bill of Lading Net Qty29,91619,03524,96419,03024,99024,985
Accepted Volume U.S. Gallons0000000000000007,907005,031006,5980005,0306,6056,604000
Difference b/w individual receipts & VOPAK value0000000000000002200-8009000-835000
Grand Total VOPAK/Billed U.S. Gallons for the Month37,774Data entry: The days of the month are across the top and the buildings are down the side. Go to the date of fill and then type in the liter value from the individual receipt for each building in the purple cells. At the bottom of the spreadsheet, put in the total VOPAK value for that date in the purple cells on the row across the bottom. The rest will automatically calculate.

Nov2015

YEARMONTHRAF Lakenheath (RAFL) and RAF Feltwell (RAFF) Org Code 909 Diesel FuelConversion factor for fuel at local weather factors
2015NOVLiterx0.264301=U.S. Gallons
Tank fill volume in LitersDAY OF THE MONTHTotal Month Liters for the Building/TankTotal Month U.S. Gallons for the Building/Tank
12345678910111213141516171819202122232425262728293031
BLDG. #1700
3914,99710,00824,99717,49567,49717,840
5200
5300
6510,0008,0007,50025,5006,740
7300
8000
947,0007,0001,850
12900
17600
19000
19100
19200
19300
19500
19600
19700
19800
19900
20000
20100
20200
20300
20400
20500
20600
20700
20800
20900
21000
21100
21500
21600
21700
21800
21900
22000
22100
22200
22300
22400
22500
22600
24900
31000
31100
31200
31300
31400
31500
31600
31700
31800
31900
32000
32100
32200
32300
32400
32500
32600
32700
32800
32900
33000
33100
34000
34100
34200
34300
34400
34500
34600
34700
34800
34900
35000
35100
35200
35300
43100
4394,0001,7305,7301,514
44300
44800
45600
45700
45900
60800
61400
63600
64000
64100
65000
65100
65700
65800
65900
6702,7612,761730
68200
68400
69000
69200
69400
77700
80000
80400
82000
82500
82600
83300
83400
84422,00011,00533,0058,723
8808,0008,0002,114
90000
90400
9063,1403,140830
90700
90800
91300
91500
91600
91722,00922,0095,817
93000
93130,00019,53925,00017,58092,11924,347
93200
93412,88012,8803,404
94400
94620,01020,0105,289
95000
95400
95800
95900
96100
96600
96700
97200
97900
98400
98900
99100
99500
998 bowser
100300
100600
100900
101000
101100
101500
101700
101900
102700
10322,1602,160571
103500
104019,00026,00015,0016,41428,50530,00620,00024,000168,92644,647
104700
106500
107000
10711,5801,580418
107200
107300
107500
107600
108000
108110,0004,66614,6663,876
108200
108400
108500
108600
108700
109400
109800
110000
110200
110400
110600
110700
110800
111900
112000
112500
112700
113800
114000
114600
114800
115600
116500
120000
120100
120500
121000
121211,60111,6013,066
12154,3804,3801,158
121700
121913,68136,01712,74629,50191,94524,301
122000
122300
122519,00019,0005,022
12266,0006,0001,586
122700
123400
123500
123600
123900
124000
124100
124300
124500
126100
126300
126600
127300
128000
128100
128300
128400
128600
128800
129000
129200
129300
129400
129500
130210,00110,0012,643
130400
13071,5011,501397
130800
1310505013
131100
131200
131300
131400
131600
131900
132000
132200
13241,2691,269335
132500
132600
132500
133200
134500
134600
137000
138400
138500
138600
138900
1391502467969256
13922,4122,412637
139500
139700
141700
141800
141900
143900
145100
146400
147300
147600
149200

This is the start of the file's text. The full file is on GovTribe.

File details come from the government source that posted it.