IMPORTRANGE and Query say column does not exist
Unable to parse query string for function Query, when using IMPORTRANGE
I read a book a while ago in which a device is invented which opens up "tunnels" back through time. These tunnels cannot be traveled through, but can be used to view what happened in the past. I believe it starts out narrating the invention of the device, then skips ahead to after it is widely in use. There is another device created, a cloak of sorts,  which hides the user from the view of someone using the tunnel device. Does this ring a bell with anyone? Fine, the 's math  did in the old pop-up. That makes sense. But this is just silly. Why do I need to be notified that a post I downvoted got deleted?    (The title links next to the red -1s were removed from the screenshot by me. They're present in the real pop-up.)  So I can break out a bottle of the '82 Rothschild? It's especially pointless because there's  that caused the change.  Please don't display the Rep Signal when the change is only due to someone else's deleted posts. I have a unique problem with an older Toshiba satellite laptop that happens to be a LegacyFree laptop meaning you can't access the bios via the normal F2, Del, Esc, etc.  I can only select a boot option in the beginning such as HDD, Removeable, CD, Floppy, etc.  The problem I ran into is the bootable USB I created is appearing as a bootable HDD not as a removable device and thus it is booting from the HDD in the computer because I can't change the HDD device priority.  Is there anyway when making the bootable USB to make it appear as a USB instead of HDD?  I've been using unetbootin and LinuxLive to create these bootable USBs.  NOTE: I am aware you can access LegacyFree Bios is through a program called Tsetup or HwSetup through windowsXP problem is that The laptop doesn't have any OS currently installed. Ubuntu 18.04 Dock mouse hover tooltips - how to disable? I need to know if it is possible and how to disable the Ubuntu 18.04 Dock tool-tips for mouse hover the pinned application. I am trying to figure out how I create a downloadable PDF template of a wedding invitation design that my customers can edit themselves. They will be approx 2 fonts used on each template and the customer will need to be able to edit all text themselves.  e.g. change their names, wedding date, location etc. etc.  Basically I want to be able to sell an editable downloadable template.  So I will need to lock the artwork and "open" the text so they can edit the text only.  If you think of something like this image. That has artwork that I want to be uneditable and then has text that I want the customer to be able to edit and print out themselves at home etc. How do I make Endermen spawn more frequently? I'm playing vanilla Minecraft, and am getting ready to head to the end.  I need Eyes of Ender (and hence Ender Pearls), and in my main hunting grounds (a large desert area) as little as one Enderman may spawn per night.  Is there any way to "promote" Enderman spawning so I can get pearls more quickly? Show bigger amplitude of physical pendulum means bigger period Suppose you have a physical . It is true that as amplitude increases, the period increases. Can we demonstrate this fact without explicitly finding the period (which is pretty involved and pretty messy) in:    an intuitive fashion,  rigorously? Number of ways in which $5$ boys and $5$ girls are ordered in such a way that exactly $4$ girls stand consecutively in the queue Let $n$ be the number of ways in which $5$ boys and $5$ girls can stand in a queue in such a way that all the girls stand consecutively in the queue. Let $m$ be the number of ways in which $5$ boys and $5$ girls in such a way that exactly $4$ girls stand consecutively in the queue. Then find $\frac{m}{n}$.    I could find $n$ correctly as $6!\times 5!$, but I am finding $m$ as $7!\times 4!\times \binom{5}{1}$, but the book says $m$ is $6!\times 4!\times 5\times \binom{5}{4}$. Where have I gone wrong? What is the proper logic to find $m$? While using the mobile site on my Android phone, I saw a comment that I wanted to flag but there was no flag button. After searching, I saw  that says flagging comments is not supported on mobile site.  Could the ability to flag comments be added to the mobile site? Objects vs arrays in Javascript for key/value pairs Asking users to accept answer when they comment that it answers their question I've had a couple of answers today where the OP indicated via a comment that I solved their problem, but the question wasn't upvoted or accepted.  In both cases the person probably wasn't able to upvote since they were new, but they could have accepted my answer. I felt a little guilty asking them to accept the answer, but since it solved their problem I felt that it would help others who stumbled on the question trying to solve their own problem to know that my solution really was the answer. Is asking the OP to accept your answer when they've said that it solved their problem a reasonable thing to do or does that feel like nagging for reputation? Can't install Skype 4.3 on Ubuntu 14.04 64 bit First of all, I think this question is not duplicated, because I have tried all other solutions I found here, but nothing solved my problem.  I use Ubuntu 14.04 64 bit.  I have tried until now: sudo apt-get install skype -> It didn't work. The error was:   The following packages have unmet dependencies: skype : Depends: skype-bin E: Unable to correct problems, you have held broken packages.   I have tried sudo dpkg add-architecture &amp;&amp; sudo dpkg -i skype-ubuntu-precise_4.3.0.37-1_i386.deb but it didn't work either. The error was:  dpkg: dependency problems prevent configuration of skype: skype depends on libqt4-dbus (&gt;= 4:4.5.3); however: Package libqt4-dbus is not installed. skype depends on libqt4-network (&gt;= 4:4.8.0); however: Package libqt4-network:i386 is not installed. skype depends on libqt4-xml (&gt;= 4:4.5.3); however: Package libqt4-xml:i386 is not installed. skype depends on libqtcore4 (&gt;= 4:4.7.0~beta1); however: Package libqtcore4:i386 is not installed. skype depends on libqtgui4 (&gt;= 4:4.8.0); however: Package libqtgui4:i386 is not installed. skype depends on libqtwebkit4 (&gt;= 2.2~2011week36); however: skype depends on libstdc++6 (&gt;= 4.2.1); however: Package libstdc++6:i386 is not installed. skype depends on libx11-6; however: Package libx11-6:i386 is not installed. skype depends on libxext6; however: Package libxext6:i386 is not installed. skype depends on libxss1; however: Package libxss1:i386 is not installed. skype depends on libxv1; however: Package libxv1:i386 is not installed. skype depends on dpkg: error processing package skype (--install): dependency problems - leaving unconfigured Processing triggers for hicolor-icon-theme (0.13-1) ... Processing triggers for gnome-menus (3.10.1-0ubuntu2) ... Processing triggers for desktop-file-utils (0.22-1ubuntu1) ... Processing triggers for bamfdaemon (0.5.1+14.04.20140409-0ubuntu1) ... Rebuilding /usr/share/applications/bamf-2.index... Processing triggers for mime-support (3.54ubuntu1) ... Errors were encountered while processing: skype   I have tried to use after sudo apt-get -f install but it didn't solve the issue.  I have tried to install by using Gdebi. The error was:  Cannot install 'libqtwebkit4:i386'   I have tried to install using Ubuntu Software Center. The error was:  Cannot install 'libqtwebkit4:i386'   I have tried changing the server in "Software and Updates". I have tried to use "Main Server" and "Servers for United States". But it couldn't solve my problem.  Anyone has any idea how to solve that?  SOLVED  Well, I formatted my pc and I installed Skype first of all. Probably another installation that I had done before the Skype installation was the problem, i guess.  Thanks people! 'longtable' caption without incrementing 'table'? For reasons both complex and confusing, I would like to caption a longtable without incrementing the table counter in the process.  I want to have two consecutive longtable environments to be captioned with identical table numbers; i.e. one longtable captioned "Table x.y: Data Set (Part A)" and one captioned "Table x.y: Data Set (Part B)", with x.y being identical for both tables.  Apparently however, even \caption*{} command bumps table. I am a bit at a loss here.  Note: I know that the xtab package would enable me to have one long table with switches of headers and captions mid-table. However I got a (different) problem with that package, akin to  but sadly not solved by egreg's answer there; so this question should be considered longtable-only as xtab, supertabular etc. don't float my boat right now. :-( How can I solve "Be aware that removing the lock file is not a solution and may break your system"? I did: sudo apt-get update  I got this: Reading package lists... Done E: Could not get lock /var/lib/apt/lists/lock. It is held by process 1131 (packagekitd)  N: Be aware that removing the lock file is not a solution and may break your system.  E: Unable to lock directory /var/lib/apt/lists/  I used to just remove the lock file, but I've never seen that note before (did it break my system?)?? What do I do? How to deal with "java.lang.OutOfMemoryError: Java heap space" error? I followed Mike's solution from my first question:    My next question is how to add entries (for the abstract and acknowledgements pages) into the table of contents. Why is len(Posts.body) incorrect on answers in data.SE? I was trying to find a longest answer on a site, and ran into a weird discrepancy:  shows that  has a length of 36388 (length in the query is defined as LEN(Posts.Body)) Yet, the post clearly only has ~26000 characters, as measured 2 ways:  Copy/pasting full text of the answer in my text editor gives me 26040 characters (the source of the answer with all the markdown, not the rendered text which is even smaller).  Trying to post a new answer that consists of this answer's text twice gives me an error &quot;Body is limited to 30000 characters; you entered 52258&quot; - meaning that the length is under 26100 (not 100% sure where the difference in counts comes from as far as two methods)   Another example from same query:  shows len(body) of 33738 whereas the text of the answer has only 29000 characters. This clearly isn't showing rendered characters, as the rendered character count is LOWER than actual answer text when editing (e.g. links add characters, as do images). How can this data.SE discrepancy be explained? Is "performance" singular or also plural? Why should I install hardware drivers if my computer is working fine? I've just installed Windows 7 on my PC.  I went online to look for drivers. For , Foxconn offers LAN drivers, on-board audio drivers, and chipset drivers. And for , Nvidia offers a graphics card driver, obviously.  But then I stopped and wondered... what benefit would I gain from installing them?   The LAN cable is plugged in and I'm online; no problems there.  The on-board audio is working fine.  A quick Google tells me that a chipset is responsible for moving data around my motherboard – which seems to be happening OK!  And my graphics look perfect.    So why should I install the drivers? What would they give me, other than badly designed "management" interfaces, and pointless "notifications" whenever I plug in an audio jack?  If there are different considerations for each of the components – chipset, audio, LAN, and graphics (and any others you think I should be aware of) – please break it down in your answer.     Update: I've had a couple of answers already, saying that I'll get better stability, bugfixes, etc.   Can I slightly expand my question... Can I get all these same benefits if I install the drivers via Windows Update? And if I do this, would I avoid having to install the vendor-specific UIs, which I find so annoying? I will give this question a little context. Firstly, as I understand it, as soon as I "close the switch" on a circuit, electric current pretty quickly establishes a steady state where, at any given cross section along a wire, the average kinetic energy of that slice is both constant and equal anywhere along the wire. (Please correct me if I am misunderstanding).   If the average kinetic energy is constant anywhere throughout the wire in the circuit (which confuses me, as I would think that the electrons should all accelerate after exiting the resistor since they are no longer being impeded as much), that means that the average velocity is constant. So, in the example of a simple circuit with a battery of v Volts and a resistor of o Ohms, my question is the following:  Because a 'voltage drop' is known to occur across the resistor, what type energy is being "traded" to generate the heat that radiates from the resistor? I would think that the reflexive answer is "electrical energy"...hence the VOLTAGE drop (the sacrificed energy is clearly not kinetic, as the velocity is constant everywhere). However, I find this confusing. Does this mean that if I had a positive test charge, it would be easier for me to bring it to the beginning of the resistor as compared to bringing it to the end of the resister?     Further, if the correct answer IS "electrical energy", why exactly DOES electrical energy get "dissipated" as the electrons pass through the resistor? I always here the comment Oh! It's because all the electrons are running into densely packed crap which impedes their flow but that to me sounds like a reason for their KINETIC energy to be reduced. However, clearly that's not the case. So, ultimately, I guess the real question is:  **What goes on in the resistor that is literally removing electrical energy **. I am sure that this is a quantum mechanics question, but my quantum mechanics knowledge is not terribly strong. If I could get an answer that is devoid of crazy wave function equations, I would greatly appreciate it. Thanks!