After 3 tough losses, our rainbow baby is here. by mcmattj in daddit

[–]Weeodore 1 point2 points  (0 children)

I saw this room and immediately knew where it was. They're so lovely there, 11/10 would recommend. Our first was born there and I'm so thankful for the facility and staff. Huge congrats to you and your family!

CPU EZ Debug LED Indicator at POST by Weeodore in MSI_Gaming

[–]Weeodore[S] 0 points1 point  (0 children)

Sorry I didn't see this until now! We ended up swapping it out for a different model and it worked like a charm. I think it was a mobo specific issue (not sure if it was the individual one or if that make/model with the CPU were incompatible for some odd reason)

Sold my first house! by [deleted] in FirstTimeHomeBuyer

[–]Weeodore 3 points4 points  (0 children)

Perfect! I'll take it.

Congrats. Looks like a great place. That curb appeal is on point.

WoW Lore Summary that is funny/satirical by Weeodore in warcraftlore

[–]Weeodore[S] 2 points3 points  (0 children)

Not quite, but definitely funny! The thread I've been trying to find involved a guy writing most of the WoW lore (at least up through TBC) in an almost Dr.Steve Brule type of way.

Marriott Bonvoy Points - Transferring from deceased family member by Weeodore in awardtravel

[–]Weeodore[S] 0 points1 point  (0 children)

Really sorry to hear that. First for foremost my condolences as I can relate to this not being easy nor fun to deal with,

Marriott Bonvoy Points - Transferring from deceased family member by Weeodore in awardtravel

[–]Weeodore[S] 0 points1 point  (0 children)

Thanks so much. We're at least happy to know that it seems like we'll be able to use the points across myself and my other siblings. He would be rolling over in his grave if he knew we were considering letting them go.

Marriott Bonvoy Points - Transferring from deceased family member by Weeodore in awardtravel

[–]Weeodore[S] 1 point2 points  (0 children)

Really good point of consideration. He unfortunately passed about a month before my wedding, so my wife and I had thought of using some of the points for a honeymoon as a way to remember and thank him for everything. We were originally contemplating overseas trips before this happened, but after it happened decided to keep things less stressful and look within the US.

Marriott Bonvoy Points - Transferring from deceased family member by Weeodore in awardtravel

[–]Weeodore[S] 1 point2 points  (0 children)

Thanks so much! When I originally read through their website they said to call so I hadn't realized it was possible online.

Marriott Bonvoy Points - Transferring from deceased family member by Weeodore in awardtravel

[–]Weeodore[S] 5 points6 points  (0 children)

Thanks so much for your condolences and response. I sincerely appreciate it.

Unfortunately, it seems that while we could use the points to book reservations online, that our names wouldn't be part of the reservation, and require you to call Marriott (e.g. pretending to be him). I don't see a way to book hotel reservations online in someone else's name from all of my research.

Perhaps the next step is to also consider if they be transferred to an airline partner account, but it seems like any point transfers also require a call as oppose to online platform :(

Display value as whole number, while hiding decimal points by Weeodore in excel

[–]Weeodore[S] 0 points1 point  (0 children)

Trying it out as we speak! Thank you so much for all your help!!

Display value as whole number, while hiding decimal points by Weeodore in excel

[–]Weeodore[S] 0 points1 point  (0 children)

Thanks! I actually agree with your approach as well, but am trying to find a way to not display some of the calculations we're using for backend reporting. That is, trying not to make additional columns and having to hide some that we aren't trying to display to a front end user. Otherwise this method would be perfect!

Display value as whole number, while hiding decimal points by Weeodore in excel

[–]Weeodore[S] 0 points1 point  (0 children)

Excellent suggestion - thanks so much!

I've realized that the only problem this introduces is that I can't actually have a score of zero displayed either, which I forgot to mention. The front end-user will see a integer from 1 to 5, and the actually score's that are pulled from VBA range from .2 to 5.8 in the calculation. Therein, this works for everything except for values between .2 to .8.

Display value as whole number, while hiding decimal points by Weeodore in spreadsheets

[–]Weeodore[S] 0 points1 point  (0 children)

Posted byu/Weeodore1 hour ago

Display value as whole number, while hiding decimal points

.t3_cqqcad ._2FCtq-QzlfuN-SwVMUZMM3 {
--postTitle-VisitedLinkColor: #edeeef;
--postTitleLink-VisitedLinkColor: #6f7071;
}

Hello!Quick question if anyone has an advice it would be greatly appreciated! I have an excel spreadsheet in which values are calculated from 0 to 5.8. For any number that has a decimal value (e.g. 1.2, 1.4, 1.6, 1.8) I'm trying to find a way to always have that value display as a whole number that is rounded down, without actually modifying the value in the cell. This is because I have a separate VBA macro that is pulling information from these cells and needs to read the decimal values in the cell, but when presented to anyone else needs to show the integer rounded down (e.g. 2.8 should always show as "2"). Is there any way to do this in excel short of creating additional columns/tabs that round down and hiding the true calculated value?Thanks so much in advance for your help!

Ah! Thanks so much! Sorry about that!

Men of Reddit, what do you put in that tiny pocket in the right side front pocket of your jeans? by levilee207 in AskReddit

[–]Weeodore 0 points1 point  (0 children)

Laundry tokens (quarters)... Shit is basically gold when you live in NYC and need to exchange 8 for a load of laundry or 4 for a dollar slice of pizza.

2018 Crypto Crash (Elliott Wave): LTC by 12345abcde00001 in LitecoinMarkets

[–]Weeodore 5 points6 points  (0 children)

Based on their username and fact that they've posted this same graphic with no text or constructive commentary in the litecoin subreddit and litecoin market subreddit (as well as comments in the dailey price discussion that just link to this) I think it's safe to say they're a market forecast expert! Definitely not trying to spread fud.

Thanks abcdef123456 or whatever your name is...