I'm getting an error message when I start QGIS3. I've tried all sorts but don't know what else to do?   Couldn't load plugin 'processing'   ImportError: cannot import name 'ogr'  Traceback (most recent call last):   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 312, in loadPlugin     __import__(packageName)   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 674, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/processing/__init__.py", line 28, in      from processing.tools.dataobjects import *          # NOQA   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 674, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/processing/tools/dataobjects.py", line 51, in      from processing.algs.gdal.GdalUtils import GdalUtils   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/qgis/utils.py", line 674, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins/processing/algs/gdal/GdalUtils.py", line 38, in      from osgeo import ogr ImportError: cannot import name 'ogr'   Python version: 3.6.5 (default, Apr 25 2018, 14:22:56) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.42.1)]  QGIS version: 3.2.1-Bonn Bonn, exported   Python Path: /Applications/QGIS3.app/Contents/MacOS/../Resources/python /Users/Lauh/Library/Application Support/QGIS/QGIS3/profiles/default/python /Users/Lauh/Library/Application Support/QGIS/QGIS3/profiles/default/python/plugins /Applications/QGIS3.app/Contents/MacOS/../Resources/python/plugins /Library/Frameworks/Python.framework/Versions/3.6/lib/python36.zip /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6 /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/lib-dynload /Library/Frameworks/Python.framework/Versions/3.6/lib/python3.6/site-packages /Users/Lauh/Library/Application Support/QGIS/QGIS3/profiles/default/python
I have installed QGIS3 from the AUR package, as well as all optional dependencies:   However, when launching, I receive the following error:  Couldn't load plugin 'processing'   ModuleNotFoundError: No module named 'osgeo'  Traceback (most recent call last):   File "/usr/share/qgis/python/qgis/utils.py", line 311, in loadPlugin     __import__(packageName)   File "/usr/share/qgis/python/qgis/utils.py", line 664, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/usr/share/qgis/python/plugins/processing/__init__.py", line 28, in      from processing.tools.dataobjects import *          # NOQA   File "/usr/share/qgis/python/qgis/utils.py", line 664, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/usr/share/qgis/python/plugins/processing/tools/dataobjects.py", line 51, in      from processing.algs.gdal.GdalUtils import GdalUtils   File "/usr/share/qgis/python/qgis/utils.py", line 664, in _import     mod = _builtin_import(name, globals, locals, fromlist, level)   File "/usr/share/qgis/python/plugins/processing/algs/gdal/GdalUtils.py", line 35, in      from osgeo import gdal   File "/usr/share/qgis/python/qgis/utils.py", line 664, in _import     mod = _builtin_import(name, globals, locals, fromlist, level) ModuleNotFoundError: No module named 'osgeo'   Python version: 3.6.4 (default, Jan  5 2018, 02:35:40) [GCC 7.2.1 20171224]  QGIS version: 3.0.0-Girona Girona, exported   Python Path: /usr/share/qgis/python /home/thiago/.local/share/QGIS/QGIS3/profiles/default/python /home/thiago/.local/share/QGIS/QGIS3/profiles/default/python/plugins /usr/share/qgis/python/plugins /usr/lib/python36.zip /usr/lib/python3.6 /usr/lib/python3.6/lib-dynload /usr/lib/python3.6/site-packages /home/thiago/.local/share/QGIS/QGIS3/profiles/default/python   It seems to be a path issue, but I am not sure how to solve it. Pacman shows gdal and python-gdal both as installed.
Compare dates in query from IMPORTRANGE and cell for a few days I'm stuck at comparing two dates.  In a big table with dates as columns and products as rows, we want to display the amount of sales per day per product.  What the following query does:   Import our sales via IMPORTRANGE query the specific sales for a given day and product ID return 0 if there is an error (e.g. not found) count the result   This is a working query with the date 2018-03-26 hard coded:  =COUNTA(IFERROR(query(IMPORTRANGE("1OHR0nr_w3oFNNxtMxRwv65xncCBRpK-vV3vvqmHGFPo"; "Sales March!A:K"); "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '2018-03-26'"; 0)))  It shows how many sales a specific product has on the specified date.  Now I want the date from a cell in the sheet:  =COUNTA(IFERROR(query(IMPORTRANGE("1OHR0nr_w3oFNNxtMxRwv65xncCBRpK-vV3vvqmHGFPo"; "Sales March!A:K"); "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '"&amp;$AR3&amp;"'"; 0)))  But this doesn't work. I tried A LOT of things for the past 3 days but I have no idea if I did that wrong (I'm a beginner) so I'm turning to you. What might be wrong with the date comparison in this section?  "select Col6 where Col6 = '"&amp;$A95&amp;"' and todate(Col11) = date '"&amp;$AR3&amp;"'"  You can see it  in Column AR Row 95 but I can't give edit rights. When to use icons vs. icons with text vs. just text links? Is it possible to repeat my track object along a path? I tried using the method shown here  using an array and then a curve modifier, but this happened when I added the curve modifier and chose the path as the curve object. How do I retrieve an HTML element's actual width and height? Suppose that I have a &lt;div&gt; that I wish to center in the browser's display (viewport). To do so, I need to calculate the width and height of the &lt;div&gt; element.   What should I use? Please include information on browser compatibility. Unable to cover get set in apex test class I am unable to cover the following class get set method. Need help in creating test class  public class Aresult{      public class Parent {         public String type {get; set;}         public String id {get; set;}         public String sequence_id {get; set;}         public String etag {get; set;}         public String name {get; set;}     } }   Please suggest  @isTest  public class CirriusGetItemsResultTest {     public static void myUnitTest(){         Aresult.parent a = new Aresult.parent();         a.type='hello';         a.id='hello';         a.sequence_id ='hello';         a.etag ='hello';         a.name ='hello';     } } The momentum-space fermion propagator in the free Dirac theory is given by       The arrow on the fermion propagator is said to represent the flow of charge.  How can we derive this statement quantitatively from the Dirac Lagrangian?  What is the quantitative form of the charge being referred to here? Possible A* Optimizations Why can't pdflatex print EPS figures? how to change landscape mode HTML form readonly SELECT tag/input Let $p &gt; 3$ be a prime such that $p \equiv 2 \pmod 3$. Define the elliptic curve $E$ over $\mathbb{F}_p$ by $y^2 = x^3 + 1$. Prove that $E(\mathbb{F}_p)$ consists of $p+1$ points.  Using Fermat's little theorem you can prove that $x^3 + 1$ is a bijection on $\mathbb{F}_p$. Hence, $$\#E(\mathbb{F}_p) = \#\{(x,y) \in \mathbb{F}_p^2 : y^2 = x^3 + 1\} + \#\{\infty\} = \#\{(x,y) \in \mathbb{F}_p^2 : y^2 = x\} + 1.$$ But then I am stuck trying to prove that $y^2 = x$ has $p$ solutions $(x,y) \in \mathbb{F}_p^2$. Let   consider   a  square $10\times 10$   and  write  in  the   every   unit  square    the   numbers   from  $1$  to  $100$   such  that   every  two   consecutive  numbers  are  in   squares   which  has  a  common edge.  Then  there  are  two  perfect  squares   on  the  same line  or  column. Can  you   give  me  an  hint? How  to  start? So I have learned in class that light can get red-shifted as it travels through space. As I understand it, space itself expands and stretches out the wavelength of the light. This results in the light having a lower frequency which equates to lowering its energy.  My question is, where does the energy of the light go? Energy must go somewhere!   Does the energy the light had before go into the mechanism that's expanding the space? I'm imagining that light is being stretched out when its being red-shifted. So would this mean that the energy is still there and that it is just spread out over more space? I have an interest in contour integration. I am not that good at it, but I enjoy learning what I can about it.  Here is a version of a rational log integral rarely encountered.  $\displaystyle \int_{0}^{1}\frac{\ln(x^{2}+1)}{x+1}dx=\frac{3}{4}\ln^{2}(2)-\frac{{\pi}^{2}}{48}$  I can do this using real methods (via double integral and substitution). I can post my workings if anyone would be interested.  My question is, can this be evaluated using contour integration due to the limits being $[0,1]$ instead of $[0,\infty)$?.  Contours may not be the most efficient way to go about it, but what is the course of action when the limits are 0 to 1 instead of 0 to infinity?. What is the longest word you can come up with that the letters are all in alphabetical order? It's Friday again, how about some fun to get us into the weekend?  What is the longest word you can come up with for which all the letters in that word are in alphabetical order?   Rules:   English words only    Can't be a name of a place, person or other proper noun.   if it contains the same letter twice in a row, that does not disqualify it.   No fair looking it up on Google!   Update: One more rule to help you guys out.   The word can be in either ascending or descending alphabetical order. Showing this metric space is complete Let $X=(0,1]$ and $d(x,y)=\left|\frac{1}{x}-\frac{1}{y}\right|$. I've proven $(X,d)$ is a metric space but I don't know how to show its completeness. How can I do that? I have the following annoying problem with Excel 2010. I use Conditional formatting to apply bold formatting to each line of the spreadsheet that meets a condition expressed by a formula. In the "applies to", I write =$A$2:$Q$149, which is the current extent of my spreadsheet. But I want this range to grow with my spreadsheet, i.e., I want the formatting to permanently apply to the whole spreadsheet. Regularly, my "applies to" field is transformed into a complex range, that selects most lines of spreadsheet, but not all, like =$A$2:$Q$138;$A$140:$Q$147. Have you ever encountered such a problem? Is there a solution? Verb/Subject Agreement Make/Makes Is "has or will read" grammatical? I just wrote  in an ELL chat room. But looking at it (or more accurately, listening to my "inner voice" trying to "read it aloud"), I find it bothers me a lot.  A quick check on Google Books finds a claimed 432 written instances of , and 910 instances of , which suggests a significant minority of writers don't have a problem with the fact that the two different read's don't sound the same.  When I check the same construction with other verbs that don't have the same written form for past participle and present tense, it seems people nearly always include both (e.g. :1230, :8; :357, :7).  I'm not usually a big fan of "grammatical rules", but it seems to me there "ought" to be a rule that you shouldn't delete one instance of the verb unless it's "the same" as the one you're keeping. And it also seems to me that since language is primarily spoken, "the same" ought to mean "sounds the same when spoken", not "looks the same when written".  Can anyone who knows more than me about formal rules of grammar settle this one?    As an aside, offhand I can't think of any verb where the past participle and present tense sound the same but are written differently (maybe there aren't any), but would deletion be okay in that case? El Capitan froze and rebooted (Macbook Pro Retina Mid 2012) 2.3 Ghz Intel Core i7 8GB DDR3: Was running NetAdmin Pro which is monitoring  my office LAN, processors consumption was at  ~15 - 20%. Simultaneously I ran WiFI Explorer,  3.7% no more than 5% CPU usage. And I was  updating Xcode to v 7.3.1 and was browsing and  watching video from playground.ru Watch the videos until half of it (20mins) the Video froze I moved the mouse and turned out  the whole OSX is frozen. littleSnitch v 3.7 has no reaction I immediately pull the Ethernet adaptor and  MacBook just went to black screen. I then  switch off the wireless router. (My MacBook Pro  is connected to the network via Ethernet  adaptor and via WiFi router bearing different IP, I was thinking of cutting both network  communication, in case it was an intrusion) MacBook just restarted itself to login screen,  after 15-20 sec of black screen and total  silence) I again restarted and booted into Recovery  mode use disk utility. After completing disk  check. Login and previously opened programs resume  back (NetAdmin Pro, WiFi Explorer, Yandex  browser, Activity Monitor and AppStore) AppStore doesn't resume the download  everything else is functioning normally and in Addition I have got my calendar open after login (I did not launch accidental nor was it set to  start with system login)   Question 1: Are there any way to know what was happening and what was OS El Capitan last reaction before it froze and rebooted?  Question 2: Are there any software better than "Console" v10.11 to interpret what was going on before it crashes?  P.S. Thank you in advance, I will try to upload the Console messages later from the MacBook Pro    DDT-2:~ Chaleune$ syslog | grep -i "shutdown cause"  Jun 22 14:15:37 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 22 20:34:46 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 23 15:18:23 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 24 17:58:32 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 24 20:09:52 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 24 22:58:15 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5Jun 25 14:43:36 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 25 21:55:31 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 3  Jun 25 22:20:57 localhost kernel[0] &lt;Notice&gt;: Kext com.apple.driver.AppleOSXWatchdog failed to load (0xdc008012).Previous shutdown cause: 5  Jun 26 10:18:44 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 26 12:09:45 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 26 18:00:31 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 27 13:05:58 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 27 22:56:11 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  Jun 28 14:18:27 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: 5  *Jun 29 18:56:21 localhost kernel[0] &lt;Notice&gt;: Previous shutdown cause: -128*  Jun 29 23:31:22 DDT-2 kernel[0] &lt;Notice&gt;: Previous shutdown cause: -128      shows the following   dsIllInstErr                  = 3,    /illegal instruction error/ dsChkErr                      = 5,    /check trap error/ userCanceledErr               = -128    gave the following interpretation:   03 Illegal Instruction The computer has a specific vocabulary of machine language instructions it can understand. If a computer tries to execute an instruction that isn't in its vocabulary, you see this error code. It's less likely than error 02, but still very common. 05 Range Check Error Programmers can use an instruction in the Motorola 68000 to check if a number is within a certain range. This error indicates that the number tested isn't in the specified range. -128  userCanceledErr         User canceled an operation