What's new

Discussion Duplication Sell Time Document on Google Sheets

  • Thread starter Bahawolf
  • Start date
  • Views 1,284
B

Bahawolf

Enthusiast
Messages
102
Reaction score
60
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. :smile: 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:
S

Shylittlemonkey

Enthusiast
Messages
38
Reaction score
7
Owning a clock does the same thing?
 
B

Bahawolf

Enthusiast
Messages
102
Reaction score
60
Owning a clock does the same thing?

Of course it does.

It just simplifies the process for me, as well as a friend. Furthermore, it provides a fairly quick visual representation of where you are in the cycle of selling. That being said, I simply posted it as it helps me, and I thought it might help someone. I wouldn't assume that it could or would help everyone, because as you clearly pointed out, people can rely on simple math on their own. However, if it isn't all that helpful to you, it really shouldn't matter all that much to you. If it helps even one person keep track of their selling, I'm happy that I posted it.
 
G

Gunzerker0

Enthusiast
Messages
185
Reaction score
40
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. :smile: 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



Sorry, the file you have requested does not exist?
 
P

Pyroman

No
Super Moderators
Messages
5,978
Reaction score
5,603
Sorry, the file you have requested does not exist?
If you read what OP said, you could access it. I had no trouble with it

"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"
 
G

Gunzerker0

Enthusiast
Messages
185
Reaction score
40
Got it to work. ta
 
Last edited:
G

gl1tangerine

Trevors left nipple
Messages
480
Reaction score
317
Thanks for sharing OP.

I always stick to the "two on two off" principal. I sell two vehicle when i come online of an evening and two before I log off.
 
B

Bahawolf

Enthusiast
Messages
102
Reaction score
60
Thanks for sharing OP.

I always stick to the "two on two off" principal. I sell two vehicle when i come online of an evening and two before I log off.

Any time. I typically do about the same, because of a lack of time for playing. :tongue: However, some of the community (including a friend of mine) has a bit more time to play. Oh, and on the weekends I have much more time to sell as well. I was using a Notes app on my phone for the last few days, but this was a fun little project of mine. It didn't take long at all to put together, and I could adjust it when / if the selling guidelines change. I just like that at any given point, I can quickly identify how many vehicles I can sell. :smile:

Furthermore, if someone has their own rule of thumb (for example, one hour between each car), you're able to adjust the formula easily! The conditional formatting that controls the colors is a nice touch as well.

I'm just so happy to see that it's helped even a few people. I'm rather new to the community, and I'd like to give back in any way that I can. :smile:
 
E

EyeDuDab

Banned
Messages
3,530
Reaction score
3,077
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. :smile: 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



the link provided by email to download :wink:
Code:
https://mail.google.com/mail/u/0/s/?view=att&th=1622bc83911a3157&attid=0.1&disp=attd&safe=1&zw
 
Top Bottom