I've been looking for answers to my need, but seem to keep finding answers to the opposite problem.  Here is my challenge.  I have a google sheet to process payroll.  On the first tab is data submitted via a form from my staff - their timesheet.  All that data is reference by tab 2 in order to prepare a template for uploading to our payroll processor.    Whenever I sort the data in tab 1 by name, to keep it alphabetical as we add and remove staff, the cell references get thrown off.    I need a way to tell it, "no matter what line John Smith moves to, always reference the data from that line and place it in the designated line in tab 2."   How do I do this?
I have this, in D1:  =sum(D3:D)   I want D1 to always be the sum of the rest of column D (D2 is a header)  I sometimes move a row, from eg 8 to 3, and that causes D1 to change to sum(d4:d).    I want D1 to stay as my sum of the column.
I was wondering whether the time shown is the time I would be arriving in France so its time zone etc.  I know France is an hour ahead so not sure if I'm right in my assumption... It would be useful to know as I plan on traveling to the States and other European countries soon as well. How general is the Lagrangian quantization approach to field theory? Do professors get paid for supervising students? Is there a way to get the name of the currently executing method in Java? How to redirect apache /var/www to the home directory and access all the directories and files in my home directory? why does files (nautilus) open a new window although there's one already open? When I click on "files" in the launcher it opens another window although the normal action is to maximize the window already open. It doesn't always do that. Is it a bug? Subclassing tuple with multiple __init__ arguments PrintWriter append method not appending Argument list too long for ls I get the following error when trying to ls *.txt | wc -l a directory that contains many files:  -bash: /bin/ls: Argument list too long   Does the threshold of this "Argument list" dependent on distro or computer's spec?  Usually, I'd pipe the result of such big result to some other commands (wc -l for example), so I'm not concerned with limits of the terminal. I constantly stay up to date with each new release of Blender, but this means my preferences are wiped clean each time. How do I export/import these preferences to avoid loosing my carefully crafted set up each time? What happens if you miss a connecting flight? How do I mention my own products in answers? Twice now I've seen questions on Stack Overflow where one of my company's products might provide an answer to the question.  One was a slightly vague connection about object-relational mapping, but the other was a specific question about workshop/event management where we have a product which is almost an exact match for the questioner's needs.  Of course the questioner should take a pinch of salt with anything I say about it, but it might be useful to have the product brought to his attention as one possible solution.  What are the rules and guidelines about answering with something I worked on? How does searching a file (locate) or autocompletion work? I am a Windows user and coming from Windows with all the indexing and eternal wait times when searching for files, I find it surprising how fast does locate work or the autocompletion (that I know) work in linux.  Is there any indexing being done in the background or how is this achieved? I still have a pretty clean installation, so maybe this goes bad with time, but in Windows the moment you want to search on a folder which is not indexed you have to wait for some seconds. Help with footer always to bottom How to edit / how to format box overlapping with footer when scrolling down I just edited an answer on Unix&amp;Linux and when scrolling down, the semi-transparent right sidebar boxes "How to edit" and "How to format" kept their fixed positioning and overlapped with the page footer.     While posting this, I have seen several (not) duplicate questions about this issue, and although from my personal taste, I would prefer the boxes to stop scrolling before the footer is reached, I can accept the development teams decision to let it overlap.   However, on all those other posts, the boxes had an opaque background, so that the footer was hidden and the box content was readable. Here the boxes are transparent though, so the texts get mixed and are no longer well readable. Why must fermions be antisymmetric? I have read that fermions cannot exist in the same state simultaneously. I understand why indistinguishable particles with an antisymmetric superposition of states can't exist in the same state simultaneously, but why must fermions have an antisymmetric superposition of states?  The only characterising property I know of fermions having besides antisymmetry is spin, for which they have half-integer. I understand that this is the case simply because particles with half-integer spin and particles with zero or integer spin were defined as fermions and bosons respectively.  My perusal of the Wikipedia page on the  leaves me under the impression that spin has nothing to do with the wavefunction's symmetry properties:     Naively, neither has anything to do with the spin, which determines the rotation properties of the particles, not the exchange properties.   Are antisymmetric wavefunctions simply classified as fermions, in the way half-integer spin particles were? I don't see how this could be the case, as, if spin and symmetry were independent, half-integer spin particles with symmetric wavefunctions (and antisymmetric integer spin particles) would be possible. C# 3.0 auto-properties — useful or not? Note: This was posted when I was starting out C#. With 2014 knowledge, I can truly say that auto-properties are among the best things that ever happened to the C# language.  I am used to create my properties in C# using a private and a public field:  private string title; public string Title {     get { return title;  }     set { title = value;  } }   Now, with  3.0, we got auto-properties:  public string Title { get; set; }   I know this is more a philosophical/subjective questions, but is there any reason to use these auto-properties except from saving five lines of code for each field? My personal gripe is that those properties are hiding stuff from me, and I am not a big fan of black magic.  In fact, the hidden private field does not even show up in the debugger, which is OK given the fact that the get/set functions do nothing. But when I want to actually implement some getter/setter logic, I have to use the private/public pair anyway.  I see the benefit that I save a lot of code (one vs six lines) without losing the ability to change the getter/setter logic later, but then again I can already do that by simply declaring a public field "Public string Title" without the need of the { get; set; } block, thus even saving more code.  So, what am I missing here? Why would anyone actually want to use auto-properties? Which infinity is meant in limits? For example, when we write $\lim_{x\rightarrow \infty} f(x)$ - which infinity is meant and why? Countable? If uncountable - which and why? Can't reach wi-fi signal on Ubuntu, but can do it on other OS/devices (ath9k) I am a relatively recent graphic design graduate. I have been working at a small printing house for about two years, but will soon be interviewing for a different position in another city.  My question is about what to include in my design portfolio. When I was in school, my professors all insisted that work included in a portfolio should be 100% original: my original photography, my original logos, my original layout, my original written content etc. However, at my current office, we rely heavily on client-supplied logos, type content, and photography—and stock photography (shutterstock, etc).  What do other designers include in their portfolios? Has anyone else had this issue and can I reasonable include these more recent projects in my portfolio if I label them appropriately (something like "layout design")?