Hi everyone,
I work for a company that deals in gas and I'm trying to create a simple spreadsheet that works out the amount of litres we have in storage and how many litres we require for our days work
So far I have converted our bulk percentages into litres (1% of storage = 699.12 litres) and worked out how many litres we have in total storage, but now I need to work out how to divide that total between all of our vehicles and convert it back into bulk percentage to make it easily usable.
Where this gets tricky is that our vehicles are different sizes so they all take different amounts to fill to the same percentage (e.g. 1% of one vehicle is 191 litres, 1% of another vehicle is 282 litres). To make things even harder they all fill to different percentages (e.g one vehicle can only be filled to 78% but another vehicle can be filled to 85%)
So in basic terms what I need to know is this:
1. Is there a way I can average the total from one cell into 5 different cells?
2. Is there a way I can get the spreadsheet to take the total amount of litres and fill the vehicles to the same percentage while taking into account the different amount of litres that each vehicle requires to reach 1%?
3. Is there a way I can cap each vehicle at its individual fill capacity and leave the remainder in a "spare gas" cell?
Any help on this would be greatly appreciated as it's driving me mad!
Thanks
I work for a company that deals in gas and I'm trying to create a simple spreadsheet that works out the amount of litres we have in storage and how many litres we require for our days work
So far I have converted our bulk percentages into litres (1% of storage = 699.12 litres) and worked out how many litres we have in total storage, but now I need to work out how to divide that total between all of our vehicles and convert it back into bulk percentage to make it easily usable.
Where this gets tricky is that our vehicles are different sizes so they all take different amounts to fill to the same percentage (e.g. 1% of one vehicle is 191 litres, 1% of another vehicle is 282 litres). To make things even harder they all fill to different percentages (e.g one vehicle can only be filled to 78% but another vehicle can be filled to 85%)
So in basic terms what I need to know is this:
1. Is there a way I can average the total from one cell into 5 different cells?
2. Is there a way I can get the spreadsheet to take the total amount of litres and fill the vehicles to the same percentage while taking into account the different amount of litres that each vehicle requires to reach 1%?
3. Is there a way I can cap each vehicle at its individual fill capacity and leave the remainder in a "spare gas" cell?
Any help on this would be greatly appreciated as it's driving me mad!
Thanks