• We should now be fully online following an overnight outage. Apologies for any inconvenience, we do not expect there to be any further issues.

What first world problem did you have today?

Page 818 - Seeking answers? Join the AnandTech community: where nearly half-a-million members share solutions and discuss the latest tech.

sdifox

No Lifer
Sep 30, 2005
100,348
17,914
126
Been looking for a 17" ryzen 4800H laptop and not finding any with just built in video. Today amazon put the asus tuf 17 on sale, which has a 1650, fine. But it won't be in stock til Christmas time...
 
Last edited:

BurnItDwn

Lifer
Oct 10, 1999
26,353
1,862
126
i ordered a new 34 inch monitor and have to wait a few days for it to be delivered because i didnt feel like driving 20 minutes to the store to pick it up in person.
 

snoopy7548

Diamond Member
Jan 1, 2005
8,258
5,331
146
I was watching some videos of Mortal Kombat 11 the other day, and I couldn't help but think, "Jesus, this is violent. Kids probably shouldn't be playing this."

And that's when I realized how old I'm getting. :(
 

pete6032

Diamond Member
Dec 3, 2010
8,148
3,586
136
Fcking hate Excel. I keep using the INDIRECT command to reference another workbook but then the values will not update or will show #N/A when I close the other spreadsheet. Too bad I didn't notice that until I used that formula about 100 times in my workbook. ugh
 

CZroe

Lifer
Jun 24, 2001
24,195
857
126
Fcking hate Excel. I keep using the INDIRECT command to reference another workbook but then the values will not update or will show #N/A when I close the other spreadsheet. Too bad I didn't notice that until I used that formula about 100 times in my workbook. ugh
I needed to take a few notes on my Galaxy Note9 (phone) last night to avoid going upstairs for a pen and paper. For once, I decided it was the kind of info that could be better arranged in a spreadsheet... pin numberings and wire colors across two devices with different numbers/colors, along with the actual function of each pin. I had never launched Excel on my phone even though Microsoft paid Samsung to include it, so I got through the initial nag screens and started putting in info. I got to the point where I needed to insert a new column and had not yet figured out how, so I selected the first column and began trying to figure out what unlabeled icon does what so I could insert a column to the left or right of the selected column. Literally the first thing I tapped sent me all the way down to something like cell 1,050,000. I think it was the auto-size or sort column button.

This is after I spend minutes scrolling up:
547dbbc069e0305bb5c56518d925ddfd.jpg

...no way to get back to my data without abusing the Find function or something.

Anyway, I quickly found that there was no easy way to scroll all the way back up. There was no scroll bar and manual scrolling kept pausing to load and took minutes to get from 1,050,000 to 1,040,000, which wasn't going to work since I was trying to get all the way back to 1. It essentially broke my simple spreadsheet by scrolling so far away from my data that I couldn't get back to it and it was literally a million times faster to make a new one and retype everything... which I did... in Google Sheets. You had your chance, Microsoft, and you blew it with a huge glitch within moments of starting. It's bad enough that mobile platforms force us to use condensed, unfamiliar, UIs with less labeling, but to complicate that with unrecoverable SCROLLING glitches is irredeemable.

Here was my final sheet when I was done in Google Sheets:
334c3f2c666e179b7ea04fbe342b2541.jpg


The Excel glitch happened after I barely had one column of colors done... literally reading them off a PCB from inside a Nintendo Entertainer System controller, since I am color-blind. The brown wire was the most confusing to me since I was trying to distinguish it from Red and wondering which was Green (neither), so I opened up an NES controller where I knew it was all labeled. This was to check the pinout and color scheme on a rare Japanese Famicom controller to see if it was the same (it is) before adapting it to an NES.
 
  • Like
Reactions: pete6032

Exterous

Super Moderator
Jun 20, 2006
20,569
3,762
126
I also had a shipping issue. My package arrived from Hong Kong in 5 days instead of the promised 14 and I didn't get a delivery notice. So it sat outside for a good part of the day when I could have been playing with my new toys!
 

pete6032

Diamond Member
Dec 3, 2010
8,148
3,586
136
My neighbor put out a bunch of motion activated Halloween decorations in his yard. One of them is a grim reaper who says things like "come closer your soul belongs to me" and "your time here has come to an end." another decoration just makes repeated blood curdling screams. I can hear both very clearly even with my windows shut. They go off at least once every 2-3 minutes with everyone walking by.
 
  • Like
Reactions: snoopy7548

snoopy7548

Diamond Member
Jan 1, 2005
8,258
5,331
146
My neighbor put out a bunch of motion activated Halloween decorations in his yard. One of them is a grim reaper who says things like "come closer your soul belongs to me" and "your time here has come to an end." another decoration just makes repeated blood curdling screams. I can hear both very clearly even with my windows shut. They go off at least once every 2-3 minutes with everyone walking by.

Does he leave it on all night?
 

BoomerD

No Lifer
Feb 26, 2006
66,288
14,706
146
My neighbor put out a bunch of motion activated Halloween decorations in his yard. One of them is a grim reaper who says things like "come closer your soul belongs to me" and "your time here has come to an end." another decoration just makes repeated blood curdling screams. I can hear both very clearly even with my windows shut. They go off at least once every 2-3 minutes with everyone walking by.

FkA5zAnI2PfUx6A5AhdLs7r1iIiuTe0kmoer5mxa7ARR1Ra4CB6uytleWVonuLSEa4Pf8c9HyPZsvUkJCQahD9mNOdVRATDdty8pvp8rdKqOOUmvRXzXYXd6EDVvrhZayvzjO7AE4S2aBw
 
  • Haha
Reactions: highland145

BarkingGhostar

Diamond Member
Nov 20, 2009
8,410
1,617
136
I've got to sit around the house all day waiting on FedEx to deliver a clearance-priced camera that requires a signature. There is a 50/50 chance it will go to the wrong address because that a-hole that lives a half-mile from me has one-letter difference in their address. Its only a $1500 purchase so who knows what will happen todfay.
 

sdifox

No Lifer
Sep 30, 2005
100,348
17,914
126
I've got to sit around the house all day waiting on FedEx to deliver a clearance-priced camera that requires a signature. There is a 50/50 chance it will go to the wrong address because that a-hole that lives a half-mile from me has one-letter difference in their address. Its only a $1500 purchase so who knows what will happen todfay.
Or it could be stuck in PA...
 

BarkingGhostar

Diamond Member
Nov 20, 2009
8,410
1,617
136
Well, according to the latest update ... at 5:53AM this morning it was placed on a truck locally for final delivery. It says the township it is being loading on, which is extremely close, so naturally that means it'll take all day. :)
 

Red Squirrel

No Lifer
May 24, 2003
70,592
13,808
126
www.anyf.ca
I found this cabin property on 32 acres I'm really eager to buy but there's a few things I want to find out first like if lack of mineral rights will restrict me form being able to drill a well or septic, or level any land to build more structures etc. Problem is, everyone I called, such as the mine that owns the mineral rights, and lawyer office, are not getting back to me. So I'm sitting here waiting or call backs, and the property could sell any time at this point. So a bit nerve wracking. Does not help that I'm at work so I don't really have time to do any further running around.
 

highland145

Lifer
Oct 12, 2009
43,973
6,338
136
I found this cabin property on 32 acres I'm really eager to buy but there's a few things I want to find out first like if lack of mineral rights will restrict me form being able to drill a well or septic, or level any land to build more structures etc. Problem is, everyone I called, such as the mine that owns the mineral rights, and lawyer office, are not getting back to me. So I'm sitting here waiting or call backs, and the property could sell any time at this point. So a bit nerve wracking. Does not help that I'm at work so I don't really have time to do any further running around.
Ask the realtor. Don't take it as gospel but they'll call a potential buyer back.
 

Red Squirrel

No Lifer
May 24, 2003
70,592
13,808
126
www.anyf.ca
Ask the realtor. Don't take it as gospel but they'll call a potential buyer back.

It's a private sale. Told the seller I'm waiting for some info though, so if they're nice they might give me some time. But at same time I don't want to hold them up in case I end up not buying, so kinda a tricky situation. Just hope the lawyer office calls me back soon. I can at least start the purchase process at that point, like the deposit etc and lay out some conditions.
 

Red Squirrel

No Lifer
May 24, 2003
70,592
13,808
126
www.anyf.ca
This is kinda an oddball one since most of the ones I looked at were listed by realtors, then I was going to just call it quits for the year and get my own realtor next year to get more serious about searching, then this one came up on FB and it's practically perfect, except for not having mineral and timber rights. Timber rights can be purchased or I can get a permit to be allowed to cut (it's cheap) so I'm not too worried about that part, and it's in middle of nowhere... if I cut a tree on my own property no one will know lol. Normally I would have seen lack of timber rights as a no go but the more I think about it, it's not a huge deal given this property already had a large area that's cleared and cabin already on it. The other thing is it has a driveway. You need a special permit for that too since you can't just branch off a road willy nilly. So lot of hastle stuff already taken care of which makes this one nice.
 

Red Squirrel

No Lifer
May 24, 2003
70,592
13,808
126
www.anyf.ca
So someone else could come clear cut the land?

No I don't think so as I did talk to the MNR about that, if it's owned by the crown then no one can cut there. But I will want to double check on that too with the lawyer just to be safe. Ideally I want to see what is involved in buying the rights as then I don't have to worry, I can just cut what I want.