T
Tim
I am in need of some help or guidance with a spread sheet I am making that
will subtract and add daily #2 Fuel oil usage for my plant. I can not seem to
come up with a formula that will add gallons and inches of fuel back in to
the row should I receive a oil delivery during the month.
Ex: On the first day of the month i have 70 inches of oil that is
multiplied by 126 totaling 8,820 gallons. On day 2 I have 66 inches of oil
for a total of 8,316 gallons and so on. Say on day 13 i am down to 50 inches
and i receive 3,780 gallons of oil it will not add back in my rows to
calculate what i just received. I do have a copy of the spreadsheet that I
would be happy to send to any one if they could contact me via e-mail with
any suggestions at (e-mail address removed)
will subtract and add daily #2 Fuel oil usage for my plant. I can not seem to
come up with a formula that will add gallons and inches of fuel back in to
the row should I receive a oil delivery during the month.
Ex: On the first day of the month i have 70 inches of oil that is
multiplied by 126 totaling 8,820 gallons. On day 2 I have 66 inches of oil
for a total of 8,316 gallons and so on. Say on day 13 i am down to 50 inches
and i receive 3,780 gallons of oil it will not add back in my rows to
calculate what i just received. I do have a copy of the spreadsheet that I
would be happy to send to any one if they could contact me via e-mail with
any suggestions at (e-mail address removed)