I need Excel sheet to manage Jet Fuel Farm stock
We have 8 Tanks for each Tank:
Tank Nominal: 53000 Ltrs
Tank Capacity: 50000 Ltrs
and three Sample Tank:
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 600 Ltrs.
We have non-blended (Jet A-1)
and blended with FSII & CI (JP8)
We have One Unloading Meter
We have One Loading meter for Tank 1 to Tank 6
We have One Loading meter for Tank 7 and Tank 8
Aviation Fuel Farm Tanks Management:
-Receipt (Purchase).
-Issue (Sale).
-Credit (Defuel or Return back to Tank).
-Transfer fuel from vehicle. -Transfer fuel from sample tank.
-Transfer fuel from Tank to Tank.
-Circulation
Fueler Trucks Management:
- Refuel Aircraft from Fueler Truck.
- Defuel from Aircraft to Fueler Truck.
- Circulation.
- Transfer fuel From Fueler Truck to another Fueler Truck.
We have a DIP Chart and System Digital Reading
We need a daily, weekly, monthly & annually Report for Tanks, Fueler Trucks and Customer wise.
We have 8 Tanks for each Tank:
Tank Nominal: 53000 Ltrs
Tank Capacity: 50000 Ltrs
and three Sample Tank:
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 800 Ltrs.
1 Tank Capacity: 600 Ltrs.
We have non-blended (Jet A-1)
and blended with FSII & CI (JP8)
We have One Unloading Meter
We have One Loading meter for Tank 1 to Tank 6
We have One Loading meter for Tank 7 and Tank 8
Aviation Fuel Farm Tanks Management:
-Receipt (Purchase).
-Issue (Sale).
-Credit (Defuel or Return back to Tank).
-Transfer fuel from vehicle. -Transfer fuel from sample tank.
-Transfer fuel from Tank to Tank.
-Circulation
Fueler Trucks Management:
- Refuel Aircraft from Fueler Truck.
- Defuel from Aircraft to Fueler Truck.
- Circulation.
- Transfer fuel From Fueler Truck to another Fueler Truck.
We have a DIP Chart and System Digital Reading
We need a daily, weekly, monthly & annually Report for Tanks, Fueler Trucks and Customer wise.