How do I loop over Excel files in a shared drive and make/save changes on each of them?
Code for looping through all excel files in a specified folder, and pulling data from specific cells
I found a feature request at  but it doesn't seem easy to get a column view with Nautilus while with Mac OS X it's a default feature.  Have I missed something or is this not currently possible? For example, if the ex-dividend date is next Monday, and I buy the stock on next Monday, would I get the dividend? Or would the person who sold the stock to me get the dividend? Referencing List by indexVar in lightning component I have nested list in my lightning component and now I want  to refer records of list using indexVar.  Has anyone done this before?  &lt;aura:iteration items="{!v.records}" var="row" indexVar="rowCnt"&gt;  Like `{!row[rowCnt]}?`  &lt;/aura:iteration&gt; How can I know the default PGF line width? Is there some macro that will tell me what the default PGF line width is? I have tried creating my own macro by cloning \pgflinewidth before it has been modified, i.e.  \let\defaultlinewidth\pgflinewidth   but \defaultlinewidth seems to be affected by \pgfsetlinewidth anyway, and change to whatever \pgflinewidth is. So, the problem is that after I have called \pgfsetlinewidth, I don't know what the default pgf line width is anymore. Is there some way to get around this? Show that the series $\sum\limits_{n=2}^{\infty} \frac {(n^3+1)^{1/3}-n}{\log n}$ converges Visualization for Euclidean Algorithm What is the proper way to change the DNS IP? How can I format my active hard drive to NTFS? I'm trying to install Windows 7 with a 4GB flash drive, but my error that comes up is that my hard drive I'm trying to install on is in ext4. I need to format it to read NTFS. I can't seem to find any topics on how to format an active hard drive. I found a topic that explains how to move Ubuntu to a new drive, but it's a bit confusing to me. System of linear equations having a real solution has also a rational solution. Solving of a seperable differential equation I have meticulously read through similar questions, answers and their comments but I still do not understand how the deletion is done. From what I understand I email the customer service and then they do what exactly?     1) They disable my account so that I can no longer use it?      2) They reassign all of my questions and answers to some other   account? To which one?      3) They delete all my questions and answers so that they go away from   public view?   What is the flexibility (if it exists) of the deletion procedure? Is it possible to erase the traces of my former association with the site. Can I request any of the following be done?     4) All of my questions and answers be deleted from public view?      5) Some of my questions and answers be deleted? If yes what criteria?      6) Can I have all of my contributions be assigned to some other   account which runs as sort of a "collective account" and already has   tons of content so that it doesn't happen like my contributions just   move to some other url but still stay grouped under that location and   therefore that location can be discovered as representing my account?      7) Can I have my contributions dispersed through several "collective   accounts?      8) Can my current public name be removed from any comments to my posts   so that my posts cannot be identified later as once belonging to me?   Please be polite with me. I wouldn't have asked if I have found the answer in the other questions. The other questions are also old and it is not clear what the situation is as per 05/2012.  UPDATE (for those interested):  I asked the Stackoverflow team about the procedure. Apparently none of the points 2-8 I asked above are possible, only 1 will take place. The link to my user page from my contributions is going to be removed and replaced with non-clickable text of an anonymized user name like "user1234". Whether this number is the same as my current user_id is not clear. That's all the information I got.  I'm going now to rename myself to "Anonymous" then request the account deletion. Those interested in the procedure will witness the exact result on this page.  Farewell. "Your Sites" in Android left sidebar shown in unpredictable order In the Android app, left sidebar, there is an editable list of "Your Sites". In the editing pane, the sites are re-orderable (although awkwardly), and the order one places the sites in there is preserved, even after quitting the app and returning to this pane. One expects that order to be reflected in the "Your Sites" portion of the left sidebar when the editing pane is closed, but it is not.  I'm not sure what is determining the order of the sites in the left sidebar, it doesn't seem to be by date they were "pinned" into the list one wants to show, either. Is there to make the login screen appear on the external display in 18.04? How does update work with programs installed from .deb file I'm having some difficulties exactly understanding how the the whole update thing work in Ubuntu and good practice for installing software.  I understand I have a  /etc/apt/sources.list file where all my repositories are listed, and that these repositories are queried when I use apt-get update - to later be used with e.g. apt-get upgrade.  This makes perfect sense and I recently installed spotify by adding deb http://repository.spotify.com stable non-free to this "sources" list.    But then I got confused...  When I went to download Google Chrome I merely had to download and grab a .deb file, and Chrome installed with no problem... but I don't see any new entry in /etc/apt/sources.list...  So how does apt-get update know where to query concerning Chrome updates?  Has it somehow been added to one of the already listed repositories in the sources file?  I would like all my installed software to be encompassed by the update function. Does $\lim_{z\rightarrow0}\frac{\bar{z}^2}{z^2}$ exist? What words are commonly mispronounced by literate people who read them before they heard them? So Black Holes Actually Merge! In 1/5th of a Second - How? I've read a lot of conflicting answers in these forums. However, today saw the awesome announcement of gravitational waves. Two black holes merged:   Not only that, they merged FAST. In 1/5th of a second revolving around each other 250 times a second. The entire event was quicker than a heartbeat. Moreover, we observed this happening as distant outsiders. So now we can say for sure:   Objects approaching the event horizon DO NOT appear to slow down Black holes CAN merge in a finite (and quick) amount of time And all this is wrt a frame of reference far, far away   To quote the NYTimes article:  One of them was 36 times as massive as the sun, the other 29. As they approached the end, at half the speed of light, they were circling each other 250 times a second.  And then the ringing stopped as the two holes coalesced into a single black hole, a trapdoor in space with the equivalent mass of 62 suns. All in a fifth of a second, Earth time.  However, everything I've read so far has let me to believe that an outside observer should never be able to measure the collision happening in a finite time. So what exactly is happening here? I must have read at lest 5 different versions of this so far everywhere in these forums over the past several years. number of quadratic residues in finite field Is there a way to determine how many quadratic residues are there in the finite field $F_q$ for $q = p^k$?  It seems if $q=p$ exactly $(p-1)/2$ are residues and the same amount are not. Does analogy holds for $q = p^k$?  Thanks for any input. I use Cygwin on my laptop (DOS). I have a collection of scripts from my colleagues, and my own. I am not an IT person, not knowledgeable in Unix. I am following my colleagues' syntax and able to manage a few simple things. The scripts worked well on my old laptop. I just changed laptop and installed Cygwin. When I run my scripts, they do not work. Here is one example of the error message I get: line 1: $':\r': command not found line 5: syntax error near unexpected token `$'\r'' line 5: `fi  Here are the top 5 lines of my script : iter=1 if [ -f iter.txt ]    then rm ./iter.txt  fi    Can someone please explain how I can get around this problem? What are good ways to make pdflatex output copy-and-pasteable?