These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Google Documents Nerds, this question is for you!
Author
Previous Topic Next Topic
Jason McCoy
Deep Core Mining Inc.
Caldari State
#1 - 2013-09-27 14:34:02 UTC
Dudes, what is the formula to substract from current? or ()now ??? Shocked

I want to keep track of my pos fuels.
I enter the current amount of fuel and in a day or two I open it back up and I want to see the updated numbers. I know this is doable, but how?

Example:
A1 has the current fuel amount; 1000 units of fuel
A2 has the units used per hour; 40 units per hour
A3 this is where I want it to show me how much fuel the pos currently has.

I did some searching poking around but to be honest I could not find the correct terminology so my searches were futile.
Lugues Slive
Diamond Light Industries
#2 - 2013-09-27 14:47:48 UTC
First you would need to timestamps A1. Then you need to get difference between timestamps and now().
Jason McCoy
Deep Core Mining Inc.
Caldari State
#3 - 2013-09-27 14:50:49 UTC
Lugues Slive wrote:
First you would need to timestamps A1. Then you need to get difference between timestamps and now().

Then calculate off the difference right?
Lugues Slive
Diamond Light Industries
#4 - 2013-09-27 14:51:34 UTC  |  Edited by: Lugues Slive
Try this, timestamps format mm/DD/yyyy hh:mm. A3=A1-A2* hour(now()-timestamp)
Invictra Atreides
Toward the Terra
#5 - 2013-09-27 15:58:53 UTC
You could also try to use EVEs API in your google sheet to retrieve the POS fuel amount automatically.

EVE API (POS) page: Link

Blog | Tutorials | Youtube "I don’t know everything, I just know what I know."
Jason McCoy
Deep Core Mining Inc.
Caldari State
#6 - 2013-09-28 22:44:41 UTC
Invictra Atreides wrote:
You could also try to use EVEs API in your google sheet to retrieve the POS fuel amount automatically.

EVE API (POS) page: Link

Actually the fuel is the least of my concerns its mostly for materials. I have various poses in various regions, the fuel is easy to sync all together, the materials are a bit more complicated and constantly change.

This is why I really want to do this.

I can the coding in, but for some odd reason when I do the time keeping on the sheets and the calculations my sheets are telling me I have less fuel than I actually have. Same thing applies to the materials.

Today I should have been close to 2200 units less compared to yesterday (which at the poses this was accurate)
BUT
On my sheets I was only like 400 units off.


grrrttttt