Tag: Reference

On a spreadsheet page I have a line chart. The x-axis labels are in $A2:$A211 the data in $B2:$D211 with column labels in $B1:$D1. Fairly basic. Column A values are actually numeric however the Scale tab of Format X-Axis only gives me choices of [automatic] [text] and [date]. I see no difference between automatic and text. Neither presents any other settings on the page to manipulate. If I select [date] I get a plethora of options but my values are not dates and cannot be formatted as dates, times, or any other temporal looking value. Because there are so many values plotted, every label can't be displayed (I wouldn't want that anyway) but because of this, it displays every 3 value. What I want is a major grid line and associated label every 7 values. The only instance of this question I could find ended with the person formatting their data to look date-ish and using the date formatting. I'm pretty sure that can't work for me (they are fractions). It seems like it sho

I bought an older laptop (Lenovo ThinkPad L530) for an older relative to use for office and browsing the internet. Unfortunately, the laptop displays clusters of green-pink pixels that flicker and appear randomly on everything. They appear before laptop enters windows, so I thought reinstalling drivers or windows would be pointless. I also tried closing and opening the lid, moving the laptop, and shaking the power adapter cable (it only works plugged, battery is dead) - no change. The problem appears when the laptop sits unused, shut down and disconnected from the socket for a while. After I open it, the issues disappears in a few hours and the next day, if I use it again, it might only show before entering windows. Although I didn't have it for long so it might also happen randomly. This is what happened so far. Here is an Imgur video of how it manifests. Could swapping the CPU fix the G

I have a worksheet that tracks issues. What I need is the ability to add new issues to the master sheet that are identified on a weekly basis. (ie keep a running list of all issues that are found and actioned during the course of a year). The master sheet and weekly data updates include a unique id cell value.

Display port to HDMI adapter, not showing up BIOS (F12) and boot logo? But it successfully boots into Windows. Using a AMD RX 570 GPU.

I have a laptop where I'm locked out of the BIOS and the boot device is fixed to the internal hard drive. I would like to install a new OS on this laptop and was wondering if the following would work: Take out the hard drive from the laptop. Install a boot manager on the hard drive using a different computer. Re-install the hard drive into the laptop. Boot into the boot manager and select an installation medium (USB or others) to continue booting from. Install the new OS on the hard drive. Would this work? How would I do step #2 and which software could I use?

I'm only considering the total inference time. I'm using a PyTorch model with CUDA for a computer vision task, and I’ve observed two different scenarios: Multiple models in parallel: In this setup, n models are launched simultaneously, each processing a batch of 1 image. The GPU is not heavily utilized, and each image takes approximately 25 ms to infer. Single model with a batch of n images: Here, one model processes a batch of n images. The inference time per image is faster, around 17 ms, but the total time becomes 17 × n, which is significantly longer. This becomes problematic in real-time applications. My question is: Could this be due to a configuration issue? And why doesn’t the batch of n images take roughly the same time as a single image, especially when the GPU isn’t saturated?

Is there any way to do this with the Replace function? Even better, I'd like to add a third line after every 2 lines containing the two previous lines combined. Is that possible?

Time to upgrade the laptop. On my current one I run Windows 11 alongside Ubuntu. I want/need to keep my current SSD. My current SSD layout is like so: Device Start End Sectors Size Type /dev/nvme0n1p1 2048 534527 532480 260M EFI System /dev/nvme0n1p2 534528 567295 32768 16M Microsoft reserved /dev/nvme0n1p3 567296 154198015 153630720 73,3G Microsoft basic data /dev/nvme0n1p4 7811987456 7814035455 2048000 1000M Windows recovery environme /dev/nvme0n1p5 154198016 299360255 145162240 69,2G Linux filesystem /dev/nvme0n1p6 299360256 7811987455 7512627200 3,5T Linux filesystem New machine comes with its own Windows 11 activated with its own license. I could try to swap the licenses (as they are both technically Windows 11) but I have no idea if that is even possible, so I thought of swapping the Windows installations. I though

I have a Raspberry Pi running as a home server, hosting several services (local DNS, Vaultwarden etc…) and from the startup everything works fine But after like 5-7 hours I'm not able to reach this host from my Windows 10 desktop. And the thing is that network seem to work fine, I can ping server from other devices on same network, and I can ping other devices from Raspberry Pi, including said Windows 10 desktop. So I'm at a loss here, I don't even know where to start debugging this. Reconnecting the Raspberry Pi to the Wi-Fi fixes it temporarily for another 5-7 hours. Maybe someone has encountered something like this and knows how to fix it?

I don't know what triggers it, there is no power outage. But almost on a weekly basis my IndexedDB data is cleared for all websites. Occasionally (every few months) my localStorage data and site login sessions are cleared. I haven't lost any other data yet. My extension data, bookmarks, browsing history are all intact to this day. What could be the issue? Also the data lost seems to have an order; IndexedDB gets lost most often, and oftentimes it is the only type of data that is lost. Sometimes when localStorage is lost IndexedDB is lost together. When login sessions are lost, IndexedDB and localStorage are lost all three.