B
Bahawolf
Enthusiast
Hey everyone!
I've setup a Google Sheets document to track my sell times, and I thought it might be useful to some of you. From my phone I enter the date and time in column A, and the rest is populated automatically.
- Column A is of course your sell time.
- Column B is the sell time, plus 30 hours.
- Column C looks for a value in column A, and checks to see if it is present in the 2 Hour window.
- Column D looks for a value in column A, and checks to see if it is present in the 30 Hour window.
This is incredibly easy for someone to recreate, but I'm happy to share the document with everyone. Please remember to only delete values from the A column, as B-D have formulas in them.
EDIT: No matter what I seem to do, it's embedding the Google Sheet, rather than putting the link to access it. Perhaps a mod can assist with that, as I wanted to save others the time of recreating it, if at all possible.
If you open another Google Sheet document, you can insert the ID of this document ("1IV6YZPn8wI47qaD0PSlHYQ5eH0Yqi3b5Ptd6x5PPtog"), and it could load that way.
Eg: https://docs.google.com/spreadsheets/d/ + 1IV6YZPn8wI47qaD0PSlHYQ5eH0Yqi3b5Ptd6x5PPtog
I've setup a Google Sheets document to track my sell times, and I thought it might be useful to some of you. From my phone I enter the date and time in column A, and the rest is populated automatically.
- Column A is of course your sell time.
- Column B is the sell time, plus 30 hours.
- Column C looks for a value in column A, and checks to see if it is present in the 2 Hour window.
- Column D looks for a value in column A, and checks to see if it is present in the 30 Hour window.
This is incredibly easy for someone to recreate, but I'm happy to share the document with everyone. Please remember to only delete values from the A column, as B-D have formulas in them.
EDIT: No matter what I seem to do, it's embedding the Google Sheet, rather than putting the link to access it. Perhaps a mod can assist with that, as I wanted to save others the time of recreating it, if at all possible.
If you open another Google Sheet document, you can insert the ID of this document ("1IV6YZPn8wI47qaD0PSlHYQ5eH0Yqi3b5Ptd6x5PPtog"), and it could load that way.
Eg: https://docs.google.com/spreadsheets/d/ + 1IV6YZPn8wI47qaD0PSlHYQ5eH0Yqi3b5Ptd6x5PPtog
Last edited: