RoyHarmon.5398 Posted September 17, 2017 Share Posted September 17, 2017 Have you ever wondered exactly when your character's birthday is?You can type "/age" and find out how many days it's been, of course, but that's not very informative on its own. Here's a tip:Type "/age" and take note of where it says something like, You have played this character for 43 hours, 20 minutes over the past 735 days. Next, open an Excel spreadsheet (if you don't have Excel, this probably also works with LibreOffice, though I haven't tested it) and type that number of days into cell A1.Then type into another cell (B1, for instance) the following formula:=TODAY()-A1And hit Enter. That's your character's birthday!I know this may not be a grand revelation to some, but it's a quick and easy way to turn the number of days into an actual date. I hope it helps! Link to comment Share on other sites More sharing options...
JustTrogdor.7892 Posted September 17, 2017 Share Posted September 17, 2017 I use https://gw2efficiency.com. It tracks birthdays with a count down when viewing characters there is an option to sort by birthday or next present. Very handy.Example when sorted by next present:https://imgur.com/j515NSX Link to comment Share on other sites More sharing options...
RoyHarmon.5398 Posted September 17, 2017 Author Share Posted September 17, 2017 Oh. Well, that's nifty. I guess my way doesn't require creating an account or anything, but it's also comparatively limited in scope. Link to comment Share on other sites More sharing options...
Myrdreth.6829 Posted September 17, 2017 Share Posted September 17, 2017 @JustTrogdor.7892 said:I use https://gw2efficiency.com. It tracks birthdays with a count down when viewing characters there is an option to sort by birthday or next present. Very handy.Example when sorted by next present:https://imgur.com/j515NSXI use https://gw2efficiency.com too. It's fast and easy. Link to comment Share on other sites More sharing options...
JustTrogdor.7892 Posted September 17, 2017 Share Posted September 17, 2017 @RoyHarmon.5398 said:Oh. Well, that's nifty. I guess my way doesn't require creating an account or anything, but it's also comparatively limited in scope.There are a lot of cool things GW2E offers. You can search for items across your account. For example if you forgot where that account bound whatever item was. It has a very handy crafting feature. You can follow your TP buy and sell orders as well as see what is in your TP delivery box and also track items for trade value. If you farm mats there is a gathering tool that shows waypoints for mats you want. There are a lot of good features beyond that. I'm not affiliated with GW2E but have been using it for a long time. It is probably the best overall web tool for GW2. I'd highly suggest looking into it. Link to comment Share on other sites More sharing options...
Myrdreth.6829 Posted September 17, 2017 Share Posted September 17, 2017 @JustTrogdor.7892 said:@RoyHarmon.5398 said:Oh. Well, that's nifty. I guess my way doesn't require creating an account or anything, but it's also comparatively limited in scope.There is a lot of cool things GW2E offers. You can search for items across your account. For example if you forgot where that account bound whatever item was. It has a very handy crafting feature. You can follow your TP buy and sell orders as well as see what is in your TP delivery box and also track items for trade value. If you farm mats there is a gathering tool that shows waypoints for mats you want. There are a lot of good features beyond that. I'm not affiliated with GW2E but have been using it for a long time. It is probably the best overall web tool for GW2. I'd highly suggest looking into it.And the daily checklist is really great! Link to comment Share on other sites More sharing options...
RoyHarmon.5398 Posted September 17, 2017 Author Share Posted September 17, 2017 Okay, then...Never mind, everyone! Nothing to see here, just go on over to https://gw2efficiency.com ! Link to comment Share on other sites More sharing options...
Myrdreth.6829 Posted September 17, 2017 Share Posted September 17, 2017 Your idea was still great, don't feel bad :) It was nice of you to share your strategy ^^ Link to comment Share on other sites More sharing options...
Greener.6204 Posted September 18, 2017 Share Posted September 18, 2017 I always appreciate the use of Excel, and your way is quick and easy (just did it now). Seems so weird to not have any vlookups or pivot tables, though... Link to comment Share on other sites More sharing options...
kKagari.6804 Posted September 18, 2017 Share Posted September 18, 2017 This topic almost feels like a well coordinated plug for https://gw2efficiency.com, not that it needs to be plugged, https://gw2efficiency.com is a great website! Link to comment Share on other sites More sharing options...
RoyHarmon.5398 Posted September 19, 2017 Author Share Posted September 19, 2017 @Greener.6204 said:I always appreciate the use of Excel, and your way is quick and easy (just did it now). Seems so weird to not have any vlookups or pivot tables, though...Yeah, I know. It felt so weird not to have a MATCH with a SMALL nested in an INDEX function or something. My typical work with Excel is pretty involved... Link to comment Share on other sites More sharing options...
RoyHarmon.5398 Posted September 19, 2017 Author Share Posted September 19, 2017 @kKagari.6804 said:This topic almost feels like a well coordinated plug for https://gw2efficiency.com, not that it needs to be plugged, https://gw2efficiency.com is a great website!https://gw2efficiency.com put my Excel quick tip company out of business. Nobody can compete with something like that! Link to comment Share on other sites More sharing options...
StinVec.3621 Posted September 19, 2017 Share Posted September 19, 2017 I primarily use https://www.timeanddate.com/date/dateadd.html to convert character age into a date, then keep track of my character stats, birthdays, Order (whispers, etc) and crafting discipline progress in a file. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.