I need to be able to assign a value (price) to each type of wine (malaje, malavia, malapipa, etc…) in the columns, so that in the final column (Bottle Sales) will appear the total price of the wine sold. I've tried several formulas, but nothing works. I should also mention that it is a Spanish version of Excel 2016 and uses ; instead of ,, MalajeMalaviaMalapipaCanibal ChardFlorMalvajioCanibal TintoVermutNaranjaEspumosoTotalBottlesBottle Sales 28111 12151212 224 13116 112217 12227 33 341513 ...| Recent Questions - Super User
The first NIC is in the 192.168.10.1/24 network, on the first pc. The second NIC has an IP address of 192.168.10.78 and connected to same network. The problem is this: we have third NIC in the second PC, in other network: 192.168.2.1/24 with an static ip of 192.168.2.2 I want to ping from the first pc network to the 192.168.2.1 network, via the second NIC with IP of 192.168.10.78 Tried to define static route in the first PC as: route add 192.168.2.0 mask 255.255.255.0 192.168.10.1 And static ...| Recent Questions - Super User
Recently, the sound stopped working in all virtual machines installed on VMWare Workstation Pro. On the host with Windows 10 and in VirtualBox, the sound works fine. When I try to turn on the sound card in the virtual machine, I get the following: Error toggling removable device: The default sound device cannot be opened: A device ID has been used that is out of range for your system. Virtual device sound will start disconnected. What I tried: Updated to version 17.6.4 (I have 17.6.3). Turned...| Recent Questions - Super User
Can RabbitMQ running in a Kubernetes cluster which consists of three nodes, continue to work when two nodes are lost? One node remains, persistent volume storage is configured, quorum queues are set up, the main question is whether it is possible to automate this mode of operation without losing the speed of data exchange.| Recent Questions - Super User
While I was looking for a way to spoof a VM environment, I ran into the Qemu program, which I think it is good enough for my purposes. After converting my .vdi file to .qcow2 and run this script on PowerShell: & "C:\Program Files\qemu\qemu-system-x86_64.exe" ` -m 8G ` -cpu qemu64,model-id="Intel(R) Core(TM) i7-6500U CPU @ 2.50GHz",kvm=off ` -machine q35 ` -smbios type=0,vendor="Insyde",version="HPQOEM - 0",date="2019-06-14T01:00:00" ` -smbios type=1,manufacturer="HP",product="HP ENVY Notebook...| Recent Questions - Super User
All of a sudden my Chrome stopped showing text on a few pages. For example that is how the internet archive looks: And this is how Facebook login looks: Interestingly, the international characters are there. Brave, on the same system shows these pages correctly. I have tried the following and nothing works: Clear cache, cookies, etc… Remove the config directory of chrome from the machine. Reinstalled Chrome. Rebuilt the font cache. Tried it on Wayland.| Recent Questions - Super User
It turns out my mouse sends left and right arrows when you tilt the scroll wheel. Which really stinks in situations where you need to middle click drag. Is there anyway to stop it?| Recent Questions - Super User
Today I got a message in Google Chrome Version 133.0.6943.141: 2 extensions were turned off These extensions are no longer supported. Chrome recommends that you remove them. DownThemAll!, uBlock Origin I assume it's related to this change to manifest v3. There, the maintainer of uBlock origin recommends to switch to Firefox. I rely on Chrome (chromium based browser to be exact) and those two extensions for my daily work. Is there any way I can keep both: using a chrome based browser and those...| Recent Questions - Super User
I'm running Everything by Void Tools - I'd like to update it to a newer version but there's no built in updater, I'm expected to install a new version from the site. Do I need to uninstall the old version before installing the new one?| Recent Questions - Super User
Let's say that there is a file F on a Linux system EXT4. F is shared through Samba. First, I open F on a Windows client. Now, a process on the Linux system updates F. But the Windows client still sees the old version of F. Closing F and opening it again on the Windows client, or terminating the Linux process that updated the file, does not seem to refresh the file (get the latest file on the Linux system). The only thing that worked was restarting the Samba service. Is there any other way to ...| Recent Questions - Super User
I'm following the advice in this other Super User question to remove or disable Edge. I first terminated it in Task Manager. Then, I tried to rename the folders, as suggested, which didn't work: I then tried to uninstall it, as suggested, which also didn't work: Edge is still opening and operating like normal.| Recent Questions - Super User
I'd like to run wireguard over tcp. I wanted to use udptunnel for sending udp packets over tcp. However, when I run wireguard and then try to run udptunnel, the udptunnel fails with the following error: setup_udp_recv: bind: Address already in use. When I try to run udptunnel first and wireguard second, wireguard fails with the following error: RTNETLINK answers: Address already in use. Used commands: wg-quick up wg0 udptunnel -s 443 127.0.0.1/51820 In the wireguard config file (wg0.conf) I u...| Recent Questions - Super User
My laptop has Global Protect installed, but settings does not have an edit, add or delete button on the general tab to allow me to change the portal address. This I need to do and I am scratching my head as to where Global Protect saves the VPN address or if need be remove the file so I can enter it in again through the UI| Recent Questions - Super User
Issue I want to stream raw RGB24 frames to ffmpeg stdin, and pipe h.264 from ffmpeg into VLC, which then serves an HTTP MJPEG stream on some arbitrary port. I can get results with either program independently but I can't get the piping to work. I doubt it matters, but this is a Raspberry Pi 4B rev 1.2 with a v1 5MP camera running Pi OS ARM32 (whatever version was newest about July 2020). Details What I have working today is a .NET Core program using MMAL with a camera on a headless Raspberry ...| Recent Questions - Super User
I want to have a threshold value in one cell (A1) and take it as a reference for adding cells. I have over 5000 lines, and more than 10 sheets. Suppose I have: A1 - 10 A2 - 4 A3 - 2 A4 - 3 A5 - 4 A6 - 6 I want to add cells based on A1 (the threshold). If A1 is 10, it would add A2:A5, sum = 13. If A1 is 9, it would add A2:A4, sum = 9. The SUM formula is: =SUM(OFFSET($A$2,0,0,MAX(INDEX((SUBTOTAL(9,OFFSET($A$2, 0,0,ROW(1:5),1))<$A$1)*ROW(1:5),,))+1,1)) But I have a problem when the sum cannot be...| Recent Questions - Super User
I want to stream the screen of my computer to and other using gstreamer and generate an rtsp adresse to use in Opencv. I try few example to stream webcam between computers and it works properly: Command on the remote computer gst-launch-1.0 -v v4l2src device=/dev/video1 ! "image/jpeg,width=1280, height=720,framerate=30/1" ! rtpjpegpay ! udpsink host=192.168.1.17 port=5001 Command on the local computer gst-launch-1.0 -e -v udpsrc port=5001 ! application/x-rtp, encoding-name=JPEG,payload=26 ! r...| Recent Questions - Super User
I like the iTerm2's Command History feature, Cmd+Shift+;, to quickly find a command from the history. But there are some commands that I want to remove from the list, I already run command like sed -i "" '/searchstring/d' "$HISTFILE" to delete them from bash history file. But when I run Cmd+Shift+;, these commands still show, where iTerm2 store them, how can I update and delete some commands from it?| Recent Questions - Super User
As I read silenceremove will reencode file. Usually I do it manually creating file like: file 'file.mp3' inpoint 0 outpoint 01:55:00.0 file 'file.mp3' inpoint 02:03:50.0 and executing this command: ffmpeg -f concat -safe 0 -i list.txt -c copy file.mp3 Maybe I can use silencedetect for creating the same file?| Recent Questions - Super User
In my BIOS settings I can set my Intel graphics card's memory from the default 256 MB to 512 MB. My laptop has a dedicated graphics card as well. Should I? What would I gain? Are there any downsides?| Recent Questions - Super User
Is there any possibility to completely disable the new Edge browser? The old IE could be disabled in “Settings → Default Programs,” but in Windows 10, the checkbox is missing for Edge. Is there any way to get rid of Edge, or at least to disable all entry-points?| Recent Questions - Super User
As mentioned here and here, bootrec.exe and bcdedit.exe have trouble functioning from a usb-booted WinPE environment. They tend to see the wrong sets of files and they also tend to break things (which I found out the hard way). As of yet, I have found no way to get them to see any file set other than that from which they were booted, IE not the WinPE environment. Booted from an actual disk, they work fine. It seems to be an issue with usb drivers in windows PE & RE from what little I was able...| Recent Questions - Super User
I finally upgraded my work PC to Window's 8.1 Pro on Monday (from 8 Pro), but since then I have been having problems with websites not loading correctly. This issue is occurring in both Firefox 27.0.1 and IE11. The website I'm trying to view does usually partially load but will not completely load. The spinner in the tab shows there is activity and clicking links does not work. In Firefox I see at the bottom the page Transferring data for www.wherever.com (IE doesn't show this though). I use ...| Recent Questions - Super User
I try to use a program and I get the following error. /usr/lib64/libstdc++.so.6: version `GLIBCXX_3.4.15' not found Under /usr/lib64 the libstdc++ I see is libstdc++.so.6.0.13 (and a soft link). With strings libstdc++.so.6.0.13 | grep GLIBCXX I get GLIBCXX_3.4 GLIBCXX_3.4.1 GLIBCXX_3.4.2 GLIBCXX_3.4.3 GLIBCXX_3.4.4 GLIBCXX_3.4.5 GLIBCXX_3.4.6 GLIBCXX_3.4.7 GLIBCXX_3.4.8 GLIBCXX_3.4.9 GLIBCXX_3.4.10 GLIBCXX_3.4.11 GLIBCXX_3.4.12 GLIBCXX_3.4.13 GLIBCXX_FORCE_NEW GLIBCXX_DEBUG_MESSAGE_LENGTH ---...| Recent Questions - Super User
Some time ago, I set up skydrive for my wife on her mac. But now she wants to access the files online, I cannot remember what Microsoft account I setup and linked her skydive app to and nor can I see anything in the skydrive app settings to tell me either? How can I see the name of the Microsoft account the skydive app is currently linked to? I would like to know this for skydrive app for Mac and PC| Recent Questions - Super User
When connecting to my own VPN server on a specific network, called public-network, my Mac disconnects the VPN connection after 2 minutes and 30 seconds. I have performed several tests and this is the result: It works fine until the 2:30 mark It doesn't matter which Mac I use, it still disconnects It doesn't matter which client I use, all of the following does the same: OSX system client, HMA! Pro VPN and Shimo It doesn't matter which protocol I use, at least all of these protocols does the sa...| Recent Questions - Super User
Is it possible to transfer audio from my local computer to a remote one, eg through SSH? I know this transfers mic to other computer dd if=/dev/dsp | ssh -c arcfour -C username@host dd of=/dev/dsp But as I didn't invent that my self I honestly don't know how to apply that for playing music?| Recent Questions - Super User
Is there any way to set the default umask for GUI applications on a mac without modifying /etc/launchd.conf or similar? I want to change it for my account without affecting others.| Recent Questions - Super User
I have to set a static IP to access the internet while I am at my work office. I usually go through the more visual of the two ways listed as answers here. Though that could change now that I know there is a cmd way to accomplish this. My question is: Sometimes after my IP has been set while working all day I shut down at night, come back the next day and it has erased the IP address and Subnet mask. So I have to re-enter both of those before I can access the internet. What could cause it to ...| Recent Questions - Super User
While it is possible to use X applications remotely by using -X switch in ssh, the sound is being played in remote machine's speaker only. For example if I view a film in VLC/Totem only video is visible and I can't hear the audio. Is there a way to forward audio too? Without digging through PulseAudio's setup, I mean; Like how SSH understands X forwarding by itself. I have tried this only in Ubuntu (in various Ubuntu versions from 9.10 through 10.10), if that helps.| Recent Questions - Super User
I'm struggling with something in FFMpeg at the moment... I'm trying to make DNxHD 1080p/24, 36Mb/s MXF files from a sequence of PNG files. My current command-line is: ffmpeg -y -f image2 -i /tmp...| Super User
I have a file server and I noticed that when I run a backup that should pull around 800 GB to tape it is only pulling around 10 GB. The job says it is completing successfully and the selection list| Super User
I have tried all of the following applications (download.cnet.com - the free ones), and none of them will convert an RAR archive to a ZIP, without compressing the files ("store" mode). 7-ZIP would be| Super User
On Ubuntu 10.04, How to enter interactive mode at boot time? Can I choose which driver to be enabled? or which Service to be enabled? System blocked at boot time, and closed screen display -- no s...| Super User
I'm reading an article on the DDR2 Memory, and now I'm totally confused. What does this line means "Since the DDR2 internal clock runs at half the DDR external clock rate, DDR2 memory operati...| Super User
I have a few embedded images in a Microsoft Word document, is there anyway to copy the images out as jpeg files?| Super User
