Fuel Calculator for Tactical Units (A Way)

Last summer, my troop command culminated with a deployment to 8 countries. Attached is a fuel calculator product that I realized with my S4, for Moldova and Romania where 3 troops in my squadron deployed. We had 2x fuel trucks available (978s) and the CSSB providing area support in the Black Sea region had 1x (5,000 gallon) fuel tanker.

Based off of this, our plan called for receiving fuel from the CSSB and as a contingency DLA (6,000 gallon tanker \"white trucks\") which made juggling the receiving, storing and issue of fuel to a squadron tricky, but not impossible. The Army has products like the LEW and OPLOG planner but for tactical units there aren\'t any tools so we made our own product. Here are its tenets:
<ol>
<li>calculate fuel consumption by each hour for each truck and tally up each day to realize when you\'ll need resupply off green/amber/red/black estimations and set trigger points for resupply accordingly using time and space logic.</li>
<li>we used fuel burn rates from the LEW/OPLOG Planner for the trucks and historical data for our unit from previous DATE rotation.</li>
<li>we did this 3 months before the deployment and during the execution consumed 10% less than what we estimated, which is how fine a margin you probably need to have when lacking storage capability.</li>
<li>we submitted our product (jokingly titled \"I-Fuel\") to the Army Petroleum Institute, and prior to deploying asked the CSSB SPO and TSC Petro-Water Section to \"red-cell\" it, which like our SPO, they thought we estimated low. OPLOG and LEW called for twice as much fuel but when you calculate the particulars (each truck, by each hour and tally up days), you get closer to what you really need.</li>
<li>I hope this product paints the picture to \"a way\" and future S-4s you can create your own to meet your needs off of the attached product and its data.</li>
</ol>