I have a spreadsheet monitoring my Stocks and cryptos etc on Google Sheets. I have a formula which 50% works and auto updates and 50% doesnt work and comes up with 'N/A : Could not fetch URL'...when multiple others are working and that one also sometimes works. The formula is; =SUBSTITUTE(IMPORTXML(&quot;https://coinmarketcap.com/currencies/&quot;&amp;A4,&quot;//div[@class='priceValue___11gHJ']&quot;), &quot;$&quot;, )*GOOGLEFINANCE(&quot;CURRENCY:USDGBP&quot;) A4 is the title box next to it so its pulling into the box in this case 'Dogecoin'. Can someone guide me with this error please?
Google Sheets has several import functions   IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML   Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that there isn't a problem with the resource content to be imported.  How do I know if these functions are able to get the content that I looking to import?  I know that there also exist IMPORTRANGE but that function only is able to import content from Google Sheets spreadsheets
What is the difference between Affection and Friendship, if any? I've risen Pokemon Amie Affection to 5 hearts on my Riolo in the hopes that it will evolve as soon as it levels up, but I'm not certain that this is the same thing as friendship, and I'd like to not waste a level.  My question is this: What is the difference between Pokemon Amie Affection and the Friendship stat? How do I bypass "this connection is not private" warnings in safari? Setting up LVM Snapshot as a backup/restore point in ubuntu Setting up LVM Snapshot as a backup/restore point in ubuntu. Why? Well, as I see it, with all the great usefulness of Linux, its biggest drawback is with its mixed up way of installing apps. All the dlls go to one directory. All the configuration files to another. And the binaries are also put in a bunch. Yes, Windows works the same way more or less, but with the nature of system/server software installed on Linux, being that most of the software installed is only about 95% mature at any given time, messing up your system twice a month is very probable.. Of course, we can backup the system before and after each installation, but that takes a million years. System backups (as oppose to just data/files backup) requires you to turn off you computer and use some form of bootable live CD and a backup media. And, if the drive is more than 15% full, it might take a long time to do the backup, even with modern hardware. So, how can this be done? Change Proxy Settings In Ubuntu I want to use the Ubuntu Software Center to install software, but I cannot download them.  How can I give my proxy settings in Ubuntu terminal (just like we use cmd in Windows to choose IE proxy settings)? Split Line at Points not splitting at every point in ArcGIS for Desktop? Why does  not split at every point encountered, even if run in an iterative fashion?  Following the suggestions of a thread here and several others, I made a set of points in order to split polylines at specified intervals. In order to do this, I used linear referencing to turn my lines into routes. Then, I exported the attribute table, divided each length by 5, and set points at multiples of 1/5 the length of the line. I used this as the event table to create a layer of events. So, each line has 4 equally spaced points along it, and I thus ultimately need the 5 segments separated by those points.  Curiously, though, when I try to do the second part "Split Line at Point," it seems that only one point is used on a given line at a time, and I'm not sure how it chooses the point (maybe order in its attribute table?) I could run the tool multiple times, but this doesn't seem to solve the problem either. For example, I could see how it would continue splitting segments as more segments are generated, but on e.g. the 4th run I see that some lines are still only split 3 times, even though there is a point within a line segment that was never split and existed before I ran the tool. I'm not sure how the splits are generated, but in any case, it doesn't seem to do what I want it to do, which is produce a split at "each" point.  What should I do to split lines at ALL points along the line? This is a canonical question and answer developed by the community to help address common questions. If you've been directed here, or your question has been closed as a duplicate, please look through the resources here and use them to shape more specific questions. To browse all canonical questions and answers, including more unit test resources, navigate to the  tag.  This canonical question is intended to address several classes of common questions by providing a quick summary and links to comprehensive resources:   How is code coverage obtained and calculated? How do I increase my coverage?  Why can't I cover these lines? Why isn't the body of my loop or conditional statement covered? I read that it is a best practice to double quote all of your variable expansions in Bash. I also read that one cannot use a shell glob (wildcard(*)) right after a double quoted variable expansion. These situations conflict when one wants use the value of a regex pattern, expanded out of a variable.   The reason I would sometimes want to combine regex with a wildcard is to keep my regex minimal, neater, in my personal taste.  My particular problem  I downloaded phpmyadmin into my document root directory and unzipped it, but I fail to rename it with mv by a regex pattern I put in a variable, and available when expanding its variable. Here's the exact trace:  userName@compName:/var/www/html# ll total 11336 drwxr-xr-x  3 root root     4096 Feb 14 07:04 ./ drwxr-xr-x  3 root root     4096 Feb 14 06:56 ../ -rw-r--r--  1 root root      612 Feb 14 06:57 index.nginx-debian.html drwxr-xr-x 12 root root     4096 Dec 23 08:50 phpMyAdmin-4.7.7-all-languages/ -rw-r--r--  1 root root 11589684 Dec 23 14:08 phpMyAdmin-latest-all-languages.zip userName@compName:/var/www/html# echo $pma [pP][hH][pP][mM][yY][aA][dD][mM][iI][nN] userName@compName:/var/www/html# mv "$pma"*/ phpmyadmin/ mv: cannot stat '[pP][hH][pP][mM][yY][aA][dD][mM][iI][nN]*/': No such file or directory   If I'll unquote the variable expansion to ${pma} I would indeed be able to combine the variable expansion and the regex, as in ${pma}*, but it is important to me to follow the best practice without exceptions, if I can.  My question  How could I keep the variable expansion double quoted, but still using the extracted value with a wildcard? How do I concatenate const/literal strings in C? Please enable low-rep users to easily breakout up and down votes on their own questions I know once you get a certain amount of reputation, you can see the total up and down votes for questions. Well, my proposal is to always be able to see this on your own questions and answers. You can see it by going to your user page anyway, so why not make it possible to do by simply clicking on the number of votes (like you can when you have the rep)? Since Chrome version 38, there's a pretty ugly button in the title bar of the Chrome window that allows you to switch profiles quickly.  Since I'm the only one that uses my computer, this is not really useful to me, and I'd rather reclaim the space for more open tabs.  I've looked in the settings but don't see a way to disable it.  How can I get rid of the button? Why does a $1/2$ appear in this simple capacitor equation? The maximum energy stored by a capacitor is when it’s (theoretically) fully charged, or just before it reaches dielectric breakdown, if you will. It seems, then, that the maximum energy ($E$) $=QV$, where $Q$ is the maximum charge attained and $V$ is the maximum ‘voltage’. However, the correct equation for the maximum energy is $E=\frac{1}{2}QV$. Why? I’m looking for a simple, intuitive explanation because my reasoning that $E=QV$ seems sound to me. I know about , but I’m looking for a reason to disprove my specific argument that $E=QV$ and not the “Oh, it comes from integration.” response. Avoiding unused variables warnings when using assert() in a Release build How to completely remove desktop? I wanted to switch to Xfce (I had KDE and GNOME installed), and I did this :    sudo apt-get install xubuntu-desktop sudo apt-get remove kubuntu-desktop sudo apt-get remove ubuntu-desktop sudo apt-get autoremove   but to my surprise, I could still pick gnome, kde plasma, etc during the log in.  So, how do I completely remove KDE and GNOME desktops? The only 1-manifolds are $\mathbb R$ and $S^1$ I recall having heard somewhere that the only 1-manifolds (second countable, Hausdorff, connected spaces locally homeomorphic to $\mathbb R$) are $\mathbb R$ and $S^1$. Is this true? If so, is there a reasonably elementary proof? $$ 3x+6y+5z=7 $$ The general solution to this linear Diophantine equation is as described    $$ x = 5k+2l+14 $$ $$ y = -l $$ $$ z = -7-k $$ $$ k,l \in \mathbb{Z} $$  If I plug the original equation into  the solution is: $$ y = 5n+2x+2  $$ $$ z =-6n-3x-1 $$ $$ n \in \mathbb{Z} $$  I can rewrite this as:  $$ x = l $$ $$ y = 5k+2l+2 $$ $$ z = -6k-3l-1 $$ $$ k,l \in \mathbb{Z} $$  However now two equations depend on two variables ($k,l$) and one on one variable $l$. In the first solution one equation depends on two variables and two on one variable.  Questions:  How can I come from a representation like the one from wolfram alpha for the general solution to one where all equations depend on one distinct variable except one equation.  Is there always such a representation? P-adic expansion construction How should I take care of my new DSLR? I am getting a new Nikon D5100 (with 18-55mm VR Lens Kit). This is going to be my first DSLR. I wanted to get some tips from you guys on how to maintain it in the long term. I am getting a 52mm UV Protector Filter, as I read that it would do well to keep the lens clean.  Are there any precautions I need to take?  I would also appreciate if someone can suggest some reading material (paperback or online). How can I disable landscape mode in Android? Can somebody please check if my proof is okay?  Prove that $||z_1|-|z_2|| \leq |z_1-z_2|$.  Attempt: This proof seems similar to the triangle inequality proof.  $$\begin{split} |z_1-z_2|^2 &amp;= (z_1-z_2) \overline{(z_1-z_2)} \\ &amp;= (z_1-z_2)(\bar z_1 - \bar z_2) \\ &amp;= z_1\bar z_1 - z_1 \bar z_2 - \bar z_1 z_2 + z_2 \bar z_2\\ &amp;=|z_1|^2 - 2Re(z_1 \bar z_2) + |z_2|^2\\ &amp; \geq |z_1|^2 -2|z_1 \bar z_2| + |z_2|^2 \\ &amp;= |z_1|^2 - 2|z_1||z_2| + |z_2|^2 \\ &amp;= (|z_1| - |z_2|)^2. \end{split}$$  Taking the square root of both sides gives $|z_1|-|z_2| \leq |z_1-z_2|$  Can I just take the norm of both sides so that $||z_1|-|z_2|| \leq ||z_1-z_2|| = |z_1-z_2|$?  Thank you. Should we put the references in slides/poster when we already have them in paper? After reading this question about  and asking myself two questions about  and , I realize that these activities are for showing what you found, make the audience be attracted. If they need further explanation, they should read your paper, which has successfully defensed and proved that your work is validated. One important thing when you attempt to attract people is concentrate on the important, which means unnecessary things need to be trimmed. I think the reference is one of those. So, should we put the references in slides/poster when we already have them in paper?