I'm trying to fetch data using importxml() but it just fails with &quot;#N/A&quot;.  I have tried it on other pages and works fine.  But it doesn't work on this site, and I don't know why. Here is the formula that doesn't work: =importxml(&quot;http://www.aastocks.com/en/stocks/quote/quick-quote.aspx?symbol=00027&quot;,&quot;//*[@id='tbQuote']/tbody/tr[1]/td[2]/div[2]/span/span/text()&quot;) Ultimately I'm trying to fetch the &quot;price change&quot; (Chg), and &quot;price change (%)&quot; (Chg(%)) elements, but all fail. What can I do to fetch these two pieces of data?  Thanks a lot!
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
build argument lists containing whitespace Is $\sum\limits_{n=1}^{\infty}\frac{n!}{n^n}$ convergent? I am currently looking for a website or a tool that would allow me to compare the package state of a particular software in different Linux distributions.  For instance, which version of gimp is provided by Mint, Ubuntu, Debian Sid and Fedora 18?  An immediate interest would be to be able to avoid reinventing the wheel when packaging software (for instance re-use patches from other distros). I am a graduate student in mathematics who would like to learn some classical mechanics. However, there is one caveat: I am not interested in the standard coordinate approach. I can't help but think of the fields that arise in physics as sections of vector bundles (or maybe principal bundles) and would love an approach to classical mechanics or what have you that took advantage of this.  Now for the questions:   Is there a text book you would recommend that phrases the constructions in classical mechanics via bundles without an appeal to transition functions?   What are the drawbacks to this approach other than the fact that it makes computations less doable? (if it does that)   Are there benefits to thinking about things this way, ie would it be of benefit to someone attempting to learn this material to do it this way? How to blur a texture node in cycles material? For a Cycles material I need to blur a texture. If the texture where a Texture Image node, I can blur the image before adding it but in my case I need to blur a Voronoi Texture and so I can't do it.  I have searched but I didn't find a blur node. Can this be achieved? Input string was not in a correct format Came across this little practice exercise, and I couldn't properly convince myself of this relation:  Let $X,Y \subset \mathbb{R}^n$ and $g:X\times Y \rightarrow \mathbb{R}$. Show that $$\sup_{y \in Y} \inf_{x \in X}g(x,y) \leq \inf_{x \in X} \sup_{y \in Y} g(x,y).$$  My thinking was starting with $\inf_{x \in X}g(x,\overline{y}) \leq\sup_{y \in Y} g(\overline{x},y)$, but does that even hold for all $\overline{x} \in X$ and $\overline{y} \in Y$? Position of a relative clause before/after a verb I'm not sure about the sentence structure below:  All kinds of problems arise that smaller animals or plants do not have to cope with.  It looks like that works as a relative pronoun for all kinds of problems, but I couldn't find such usage in my dictionary or online. This sentence could be divided into  There are all kinds of problems. Smaller animals or plants do not have to cope with all kinds of problems.  But, I can't figure out where 'arise' fits. If you have any thoughts, please share them. I know that its is the possessive and it's is the contraction, and know when to use them.  But why doesn't the possessive have an apostrophe?   "The bear's eating a fish." [contraction] "The bear's coat is brown." [possessive] "It's eating a fish." [contraction] "Its coat is brown." [possessive] "One's eating a fish." [contraction] "One's coat is brown." [possessive]    lists the etymology as "From  +‎ ", and  says that this is actually the original form:     Originally written it's, and still deliberately spelled thus by some writers until early 1800s.   So what happened to the apostrophe?  When did people stop using it, and why did they?  It seems that it's as the possessive is more natural, as most people do this until they're taught that it is wrong (or even after).  Update: Online Etymology Dictionary has been updated to include two potential explanations:     The apostrophe came to be omitted, perhaps because it's already was established as a contraction of it is, or by general habit of omitting apostrophes in personal pronouns (hers, yours, theirs, etc.).   Can anyone back up either of these arguments?  The possessive one's still has the apostrophe, despite these. What Hogwarts classes are taught to two houses at once? I remember from my mumble about nine mumble rereads of the Harry Potter series that the following classes Harry took were taught to more than one house in the same lesson:   Potions with the Slytherins  Herbology with the Hufflepuffs  Care of Magical Creatures with the Slytherins  broomstick riding with at least the Slytherins (maybe other houses, too?)    I don't remember any student from a house that isn't Gryffindor being mentioned in the sections on Transfiguration, Charms, Defense Against Dark Arts, History of Magic, or Divination. That would mean McGonagall had to teach twice as many classes as Snape, if both subjects got the same number of lessons (which I think I recall).   Were any subjects other than Potions, Herbology, and Care of Magical Creatures taught to more than one house in the same lesson? And do we know why some subjects are taught to more students at the same time than others? What is the "?" symbol in URL used for in php? I have two sites that were originally migrated from SPS2003.  It worked well in SharePoint 2007 and even on SharePoint 2010,  however when we migrated it to SharePoint 2013,  the home page throws following errors on the ULS Log.     5/24/2013 09:57:46.62  w3wp.exe (0x0D50)   0x1D24  SharePoint Foundation   Files   ak8dj   High   UserAgent not available, file operations may not be optimized.    at Microsoft.SharePoint.SPFileStreamManager.CreateCobaltStreamContainer(SPFileStreamStore spfs, ILockBytes ilb, Boolean copyOnFirstWrite, Boolean disposeIlb)     at Microsoft.SharePoint.SPFileStreamManager.SetInputLockBytes(SPFileInfo&amp; fileInfo, SqlSession session, PrefetchResult prefetchResult)        05/24/2013 09:57:46.62 w3wp.exe (0x0D50)   0x1D24  SharePoint Foundation   Cobalt  ajoii   Medium   Mapping Store error to Cobalt error. [Store Error: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.SharePoint.CoordinatedStreamBuffer.SPCoordinatedStreamBufferFactory.CreateFromDocParams(SqlSession session, Guid guidSiteId, Int32 cbContent, Nullable1 parentId, Guid docId, Nullable1 level, SPChunkedArray`1 rgbContent, Byte[] rgbRbsId, Int64 bsn, Byte partition, Int32 pageSize, Boolean bStartFilling)        05/24/2013 09:57:46.62 w3wp.exe (0x0D50)   0x1D24  SharePoint Foundation   Cobalt  aintx   High    Failed in CobaltStream.LockBytes: ErrorException --- Error: Unknown (Win32=0x80004003) --- Error message: System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.SharePoint.CoordinatedStreamBuffer.SPCoordinatedStreamBufferFactory.CreateFromDocParams(SqlSession session, Guid guidSiteId, Int32 cbContent, Nullable1 parentId, Guid docId, Nullable1 level, SPChunkedArray`1 rgbContent, Byte[] rgbRbsId, Int64 bsn, Byte partition, Int32 pageSize, Boolean bStartFilling)     at         05/24/2013 09:57:46.64 w3wp.exe (0x0D50)   0x1D24  SharePoint Foundation   Files   ak8dj   High    UserAgent not available, file operations may not be optimized.    at Microsoft.SharePoint.SPFileStreamManager.CreateCobaltStreamContainer(SPFileStreamStore spfs, ILockBytes ilb, Boolean copyOnFirstWrite, Boolean disposeIlb)     at Microsoft.SharePoint.SPFileStreamManager.SetInputLockBytes(SPFileInfo&amp; fileInfo, SqlSession session, PrefetchResult prefetchResult)     at         05/24/2013 09:57:46.64 w3wp.exe (0x0D50)   0x1D24  SharePoint Foundation   Database    ab1a9   High    Failed to get document content data. System.NullReferenceException: Object reference not set to an instance of an object.     at Microsoft.SharePoint.CoordinatedStreamBuffer.SPCoordinatedStreamBufferFactory.CreateFromDocParams(SqlSession session, Guid guidSiteId, Int32 cbContent, Nullable1 parentId, Guid docId, Nullable1 level, SPChunkedArray`1 rgbContent, Byte[] rgbRbsId, Int64 bsn, Byte partition, Int32 pageSize, Boolean bStartFilling)     at   I could not find any materials related to this on the internet,  I am not even sure if it has to do something with SPS2003 compatibility.  Any help pointers? Notify question OP (and those who marked it a favourite) if an answer has been modified Seriously, I had not noticed e.g. Jeff's edit  had he not also retagged my question. How to know if my servers should use jumbo frames (MTU) Printer service not found on port 515 For services list on my Ubuntu, Printer service not found on port 515.  nmap -sT -O localhost  PORT     STATE SERVICE 23/tcp   open  telnet 139/tcp  open  netbios-ssn 445/tcp  open  microsoft-ds 631/tcp  open  ipp 9050/tcp open  tor-socks Device type: general purpose Running: Linux 3.X OS CPE: cpe:/o:linux:linux_kernel:3 OS details: Linux 3.12 - 3.19, Linux 3.8 - 3.19       There is no Printer service on port 515. How to add Printer service on port 515?     nmap -v -p 515 127.0.0.1  Starting Nmap 7.01 ( https://nmap.org ) at 2016-11-19 13:03 IRST Initiating SYN Stealth Scan at 13:03 Scanning localhost (127.0.0.1) [1 port] Completed SYN Stealth Scan at 13:03, 0.21s elapsed (1 total ports) Nmap scan report for localhost (127.0.0.1) Host is up (0.000065s latency). PORT    STATE  SERVICE 515/tcp closed printer What is the sum of $$\sum_{n=0}^{\infty}\frac{1}{2^n(n+1)}$$    I've spent an insane amount of time on this problem. I checked on Wolfram and it gives $ln(4)$, which I assume you get from $2\ln(2)$.   I know that the integral of $\frac{1}{n+1}$ is $\ln(n+1)$. What am I missing?  Thank you! Use the beamer TOC style elsewhere Use induction to prove a product of sums of squares is a sum of squares I have a simple question but I am not sure on how to proceed. I would like to put 10 figures on the same page: a grid of 5 rows and 2 columns.  What should I type in order to have the figure inserted like this and with equal alignement/size ? Eventually with custom captions... ;) Using beamer \visible command inside a table, without adding vertical space When using the beamer \visible command inside a tabular environment, beamer adds an extra vertical space before the text. For example, in the following code, beamer adds an empty line before the word World in the second row. Can this be avoided?  \documentclass{beamer} \begin{document} \begin{frame}   \begin{tabular}{|p{1cm}|p{1cm}|}     \hline     1 &amp; Hello World \\     \hline     2 &amp; \visible&lt;2-&gt;{Hello World} \\     \hline   \end{tabular} \end{frame} \end{document}