Google Sheets importxml help
How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?
Multi-OS Portable TeX system I'm looking to treat myself to a totally portable TeX system and was wondering: is it possible to devise an installation scheme that would run on Windows, Linux and MacOS at the "same" time?  I think TeXLive is the best choice here, but I'd much rather avoid having to maintain three separate TeXLive installations. I'd like the three installations to share the package databases for instance.  I'll be using a 32Gb USB stick, in case it matters.  PS: I think I'm onto something here... will post back when I have a working prototype.  Edit: after reading  I managed to format a USB stick with UDF and have it read and written in Linux and Windows (need to perform some tests on Mac yet). This is the first step towards interoperability.  Edit 2: well, as it turns out, the previous note was useless (the partition table breaks under Windows), I've found  and it works like a charm. The only remaining step is writing a couple of scripts to set the environmental variables and we're done ;) Anyone can optimized this code for better explanation and easy to understand? Suppose a gambler starts with one dollar and plays a game in which he or she wins one dollar with probability $p$ and loses one dollar with probability $1 - p$. Let $f_{n}$ be the probability that he or she first becomes broke at time $n$ for $n = 0, 1, 2\ldots$. Find a generating function for these probabilities.  Is it binomial distribution $?$ and then use the $\operatorname{mx}\left(s\right) = rx\left(\mathrm{e}^{s}\right)$ of the binomial distribution $?$. Help$\ldots!$. I am correcting my quiz. Uninstall, Activate, Deactivate a plugin: typical features & how-to I'm making a WordPress plugin. What are typical things I should include in the uninstall feature?  For example, should I delete any tables I created in the install function?  Do I clean up my option entries?  Anything else? What do the X and Y axis stand for in the Fourier transform domain? Is $\sqrt{x^2}=|x|$ or $=x$? Isn't $(x^2)^\frac12=x?$ $|x|=\sqrt{x^2}$ as  shows. But, as $(x^2)^\frac12=x$, I can't understand where am I wrong interpreting Square-root. How to turn the white colour portion to transparent I got this map icon in work in illustrator, and would like to turn those white dash line and the white outline of the location mark to transparent. Can you please advise me how to do it? Thank you in advance. I downloaded a file from the internet (I can link to it here, but in the interests of not annoying other users, I won't post the link), and I can't delete the file with the message:   You need permission to perform this action  You require permission from the computer's administrator to make changes to this file   Trouble is, I am the administrator and UAC is completely off.  If I go into the Properties/Security tab, I get the message   You do not have permission to view or edit this object's permission settings   Clicking "Advanced"/Owner, it says:   Current owner: Unable to display current owner.   If i try to change the owner, I get the same message:   Unable to set new owner on file  Access is denied. Evaluating the sum after reordering an infinite series $1-\frac {1} {2}+\frac {1} {3}-\frac {1} {4}+\ldots $ If in the series  $1-\dfrac {1} {2}+\dfrac {1} {3}-\dfrac {1} {4}+\ldots $ the order of the terms be altered, so that the ratio of the number of positive terms to the number of negative terms in the first $n$ terms is ultimately $a^{2}$, show that the sum of the series will become $\log \left( 2a\right) $.  Solution attempt. Let $p$ be the number of positive terms in the first $n$ terms of the reordered series so based on the question we are allowed $a^{2}=\dfrac {p} {n-p}$. Now solving for p we get $p=\dfrac {a^{2}n} {\left( 1+a^{2}\right) }$ and $n-p=\dfrac {n } {\left( 1+a^{2}\right) }$.  We also observe that in the original series only the odd terms are positive and only the even terms are negative.  Let's define $S_{odd}=1+\dfrac {1} {3}+\dfrac {1} {5}+.\ldots +\dfrac {1} {2n-1}$ and $S_{even}=\dfrac {-1} {2}\dfrac {-1} {4}\ldots -\dfrac {1} {2n}$  $S_{Reordered}=S_{odd_{p}}+S_{even_{n-p}}$  $S_{Reordered}=\sum _{t=1}^{t=P}\dfrac {1} {2t-1}+\sum _{t=1}^{t=(n-P)}\dfrac {-1} {2t}$ $S_{Reordered}=\sum _{t=1}^{t=\dfrac {a^{2}n} {\left( 1+a^{2}\right) }}\dfrac {1} {2t-1}+\sum _{t=1}^{t=\dfrac {n } {\left( 1+a^{2}\right) }}\dfrac {-1} {2t}$    In order to extend $S_{Reordered}$ from n terms to an infinite length. I guess i should take the limit of the $S_{Reordered}$ as $n\rightarrow \infty $ which would make the upper values of $t$ (Not sure of technical term here) to be $\infty$ giving me   $S_{Reordered}=\sum _{t=1}^{t=\infty}\dfrac {1} {2t-1}+\sum _{t=1}^{t=\infty}\dfrac {-1} {2t}$   and i have lost the $a$ from the expression. I guess i am stuck i need to perform some step to capture a before taking the limit. Any help would be much appreciated. How do I pass a function as a parameter to in elisp? I'm trying to pass one method to another in elisp, and then have that method execute it.  Here is an example:  (defun t1 ()   "t1")  (defun t2 ()   "t1")  (defun call-t (t)   ; how do I execute "t"?   (t))  ; How do I pass in method reference? (call-t 't1) In my laptop (a Lenovo y470 ) there are three USB ports. One of those is USB 3.0 others are USB 2.0 . I do not know which one is what. When I copy data from my External HDD it transfers at 38MB/s from all of the USB ports. (Which is a good speed for USB 2 transfers, but to low for USB 3).  I used the device manager to confirm that I have one USB 3.0 port.    Is there a way a can figure out which port is 3.0 ? Recently I answered two questions on SO: The  is a completely trivial answer to a really basic question (kind of "read the manual and follow the one liner example there"). On the other hand, my  is a much more complicated answer that requires much more specialized knowledge of a very specific domain (happens to be related to my PhD research).  Clearly, the first answer could have been given by many SO users - I just happened to be the first to pick up the glove on this question. However, this is not the case for the second answer.  In contrast, when it comes to reputation - the first answer instantly got upvoted (everyone can relate to a simple question/answer), while the second one - I don't believe it will get much upvotes...  So, life isn't fair: for the one answer that really very few people could provide (the second answer) and is much harder to find and get -- is not rewarded, while the trivial answer is rewarded fast and strong...  How can we amend this? How can we encourage rare and specialized answers for difficult and deep questions?  Do we want SO to turn into a pool of trivial and superficial questions?    Update: Thanks to many meta-users who took the time to read through this question and ponder its implication, both answers I used as examples got exposed far beyond their fair-share. So, despite the fact that my original claim that the specialized answer get less reps is no longer valid, this does not change fact that in general my claim is stil valid: specialized answers requiring expert knowledge will recieve less attention at first.    Bottom line: (following my wish to have some sort of ). Indeed it sometimes seems like life isn't fair, but this is only in the short term. In the long run high quality answers do get their proper credit and exposure and their fair share of reputation. The reputation system of SO works quite well balancing and accounting for many factors and parameters. It would require a really strong argument backed up with serious research to change this mechanism.   Thank you all for the lively discussion and for showing me that life is fair after all. A mod-only section of the help center Who was the colleague that Erik was going to contact for help? After S.H.I.E.L.D confiscates Jane's work in Thor, the researchers discuss what they'll do next.  Erik mentions two colleagues. The first is reasonably implied to be Bruce Banner, but who is the second colleague he mentions? Transcribed from the film:  Jane Who are these people? Erik I knew this scientist... a pioneer in gamma radiation. S.H.I.E.L.D showed up and... umm. He wasn't heard from again. Jane They're not going to do that to us. I'm going to get everything back. Erik mumbles Please. Let me contact one of my colleagues. He's had some dealings with these people before. I'll email him and maybe he can help. Darcy They took your laptop, too. Is there a reason why "gn" in "reigning" is pronounced /n/ while in "regnant" it is pronounced [gn]? Both reigning and regnant are related to the same Latin noun, regnum.  Why is the ‹gn› spelling pronounced [n] in the first word but [gn] in the second? How many solutions $X^{10} - I=0$ has in $M_2(\mathbb{R})$? How many solutions $X^{10} - I=0$ has in $M_2(\mathbb{R})$? Where $M_2(\mathbb{R})$ denotes the set of $2 \times 2$ real matrices.  I absolutely have no idea of where I should start from. $I$ and $-I$ solve the equation, but are there any other non-trivial solutions? Are there infinitely many solutions? Do we need a global test before post hoc tests? Batch script to resize height of all layers to same height but keeping their original aspect ratio I have hundreds of product image layers and I am trying to resize them all to the same height (ignoring the width) and retaining their individual aspect ratio's.  Is there a script available that does this? Or a feature I am unaware of?  Thanks! Removing lines from text file that contain string at beginning and string at end - and keep one It took me a while to word this best.  Problem 1:  Is there a way to find lines in a text file that have the same string at the beginning and the same strings at the end?   Beginning and end strings not necessarily equal to each other.  Text between the two strings is not consistant in number of characters or number of hyphens.  A hyphen is in between notable strings (which I added to my large text file).  For example:  File:    AAAAA-tjhut-ghyut-FILE1.txt   BBB-fhuj-dnbhg-frt76-FILE2.txt   AAAAA-ghtujukr-hgute7gr-xhyutt-FILE1.txt   AAAAA-VGYT-4d7tt-xhyutt-FILE1.txt   CCCC-fjuk-dryy-fhuj-FILE3.txt   Lines to detect:    AAAAA-tjhut-ghyut-FILE1.txt   AAAAA-ghtujukr-hgute7gr-xhyutt-FILE1.txt   AAAAA-VGYT-4d7tt-xhyutt-FILE1.txt   Problem 2:  Is there a way to remove all but one of the lines containing the duplicate strings at the beginning and end from above?  Before:    AAAAA-tjhut-ghyut-FILE1.txt   AAAAA-ghtujukr-hgute7gr-xhyutt-FILE1.txt   AAAAA-VGYT-4d7tt-xhyutt-FILE1.txt   After:    AAAAA-tjhut-ghyut-FILE1.txt   Big thanks for any advice.  Note: I think using the occurances of the first hyphen and last hyphen can be used to locate the duplicate strings. Object selection box with eyedropper