I have a large list of numbers. I want to group them so that the cell color is the same if the number is a sequential number. If two groups of sequential numbers are beside each other in the list then the color would need to be different.  The list is very large and to color it in manually is taking a very very long time.  If anyone can help me out it would be very appreciated.    Below is an example of a section of Excel that has been manually completed.
I need a formula for conditional formatting to make an Excel 2010 spreadsheet alternate highlighting when a single column changes.  This question, "", is exactly what I want to do, but the suggested solution didn't work for me--it just highlights the first row of each matching value.  I know how to use conditional formatting, but for the life of me I can't figure out or find any pointers on the net so far to make this work.  Ideas?  Here is a link to a picture of how I want my spreadsheet to look when I'm done.  Basically I want every other Disp Number value row to be highlighted.  Seems like it would be a common thing to want to do, and I've seen this asked for in various places, but people struggle with making it work.
How do I programmatically log in a user with a POST request? Do anyone have a working REST Login on Drupal 8? This is what I tried. POST /user/login HTTP/1.1 Host: 8.d8.local Content-Type: application/x-www-form-urlencoded Accept-Encoding: http://nikhilmohan.in Cache-Control: no-cache  name=test&amp;pass=password&amp;form_id=user_login_form  It returns me HTML instead of JSON. Where does gravity get its energy from? Referencing bib files with spaces in the filename I am using a Mac with TeX Live and Mendeley for automatically generating .bib files, some of which have spaces in the file names. I would like to know how to reference such files from LaTeX as using "" or \ doesn't seem to work. How to delete directories with path/names too long for normal delete Windows seems to have a length limit on file names when trying to delete, though it won't prevent those files from being created.  Our build process creates a number of temporary files (many build off of a WSDL) that run afoul of this limit.  Our ant script is somehow able to delete them when doing a clean, but sometimes I need to delete the workarea directory (where all the temp files go) without actually doing a full clean from ant.  This is the same errors , but the answers there don't really work for me as I'm dealing with a directory, not a file, and I don't always know what specific files or subdirectories are causing the problem.  And I'm trying to avoid any manual process (other than triggering a single command) to actually delete them.  If I try deleting the directory from Explorer I get the error   Cannot delete [file name]: The file name you specified is not valid or too long.   Specify a different file name   Trying Remove-Item in powershell gives the following error:  Remove-Item : The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. At line:1 char:12 + Remove-Item  &lt;&lt;&lt;&lt; -force -Recurse &lt;directory&gt;   Does anyone know of any tools or easy ways to get around this delete error without having to manually find the problem files and move/rename them? What are the SEO rules for HTML 5? What are the rules of engagement with respect to SEO in HTML 5?  Examples of things we have been mulling over with no conclusion:   Are you penalised for not using &lt;head&gt; and &lt;body&gt; tags? Do links in &lt;nav&gt; blocks get prioritised for follows? With &lt;aside&gt; (no bside though), &lt;section&gt;, &lt;summary&gt; and &lt;details&gt; which ones carry the most weight for content, one-liner descriptions and keyword tags are there search engine implications? If you use CSS to put a &lt;footer&gt; element at the top and a &lt;header&gt; element at the bottom (not that you would but it may be construed as such by an incomplete spider implementation)? Does the use of placeholder attributes on &lt;input&gt; show you are more user focused?   At the minute we are haphazardly pinning the content on the donkey with regard to tag usage but would be interesting to know if anyone has any insight into the "correct" tags to use with regards to SEO. How to sample from a discrete distribution? Assume I have a distribution governing the possible outcome from a single random variable X.  This is something like [0.1, 0.4, 0.2, 0.3] for X being a value of either 1, 2, 3, 4.  Is it possible to sample from this distribution, i.e. generate pseudo random numbers upon each of the possible outcomes given the probability of that outcome. So if I wanted to know what the probability of getting a 2 is, the sampling operation may return 0.34 or something like that.  The reason I ask is that I'm trying to implement an action selection policy for a reinforcement learning method based on a research paper. From what I gather from the paper, the author is able to sample the distribution by "mapping the uniform distribution U[0,1] through cumulative probability density functions obtained by adaptive numerical integration". From this he then samples the transition probabilities for each trial...  I would be grateful for any info on this...  Thanks in advance Windows wildcards with files having more than 3 characters extensions On Windows 7, I have a directory containing the following four files:   xxx.txt xxx.txt2 xxx2.txt xxx2.txt2   With the file have more than 3 character as a file extension, the behavior of the wildcard * seems odd:  dir *.txt  10/13/2014  04:14 PM                 6 xxx.txt 10/13/2014  04:17 PM                 6 xxx2.txt 10/13/2014  04:17 PM                 6 xxx2.txt2 10/13/2014  04:14 PM                 6 xxx.txt2            4 File(s)             24 bytes            0 Dir(s)   6,660,980,736 bytes free   I would expect to see only the two files with txt extension and not the ones with txt2 (like it would on a Linux machine). Does MS-DOS ignore the truncate the file extension to 3 characters or does it add automatically another wildcard at the end? If I want to delete only the files with txt extension and not the one with txt2, which command should I use? Thanks Does there exist a set L of pairwise disjoint lines, each line in an axis direction, in $\mathbb{R}^3$ such that their union is equal equal to $\{ x : x \text{ has at least one irrational coordinate}\}$? What do I do when I walk into a room with a broken item and both children shrug their shoulders and say "Wasn't me"? I'm trying to get my kids to be honest and take responsibility.   I'm seeing a repeated pattern where one or both of my kids will lie to get out of trouble. They're starting to see that they can deny responsiblity.   Our current system of reward involves a marble jar, where the family will go out for a collective treat. When this stuff happens we take marbles out of the jar as a joint penalty.   This seems to be decreasing in effectiveness.   My question is: What do I do when I walk into a room with a broken item and both children shrug their shoulders and say "Wasn't me"?  Clarification: Kids are girl: 5 and boy: 4. Cultural context is Australian middle class with two university educated parents. How to detect Windows 64-bit platform with .NET? In a  2.0 C# application I use the following code to detect the operating system platform:  string os_platform = System.Environment.OSVersion.Platform.ToString();   This returns "Win32NT". The problem is that it returns "Win32NT" even when running on Windows Vista 64-bit.  Is there any other method to know the correct platform (32&nbsp;or 64&nbsp;bit)?  Note that it should also detect 64&nbsp;bit when run as a 32&nbsp;bit application on Windows 64&nbsp;bit. Function to determine if two numbers are nearly equal when rounded to n significant decimal digits I have been asked to test a library provided by a 3rd party. The library is known to be accurate to n significant figures. Any less-significant errors can safely be ignored. I want to write a function to help me compare the results:  def nearlyequal( a, b, sigfig=5 ):   The purpose of this function is to determine if two floating-point numbers (a and b) are approximately equal. The function will return True if a==b (exact match) or if a and b have the same value when rounded to sigfig significant-figures when written in decimal.   Can anybody suggest a good implementation? I've written a mini unit-test. Unless you can see a bug in my tests then a good implementation should pass the following:  assert nearlyequal(1, 1, 5)  assert nearlyequal(1.0, 1.0, 5)  assert nearlyequal(1.0, 1.0, 5)  assert nearlyequal(-1e-9, 1e-9, 5)  assert nearlyequal(1e9, 1e9 + 1 , 5)  assert not nearlyequal( 1e4, 1e4 + 1, 5)  assert nearlyequal( 0.0, 1e-15, 5 )  assert not nearlyequal( 0.0, 1e-4, 6 )    Additional notes:   Values a and b might be of type int, float or numpy.float64. Values a and b will always be of the same type. It's vital that conversion does not introduce additional error into the function. Lets keep this numerical, so functions that convert to strings or use non-mathematical tricks are not ideal. This program will be audited by somebody who is a mathematician who will want to be able to prove that the function does what it is supposed to do. Speed... I've got to compare a lot of numbers so the faster the better. I've got numpy, scipy and the standard-library. Anything else will be hard for me to get, especially for such a small part of the project. Explain Root Mean Square Error to non-technical audience Google Chrome doesn't seem to respect my DPI setting in Windows. I run at 150 DPI, but Chrome ignores that, meaning that images and text are teeeeeeny tiny.  I hit:   Ctrl + + Ctrl + +   to zoom in. Unfortunately every new tab, or new window, defaults to the 100% teeny tiny zoom level.  Update: It's also important to note that you cannot click buttons in flash (e.g. YouTube videos), because Chrome mis-handles mouse coordinates. (Fixed 6.0.472.55)  Is it possible for either:   Chrome to respect my Windows dpi setting? Chrome to remember my zoom preference?   Checked version: 4.1.249.1045    Half fixed    While Chome still doesn't honor the Windows DPI setting, it does now remember your zoom level.  Version: 5.0.375.55    Five-Eighths Fixed    While Chrome still doesn't honor the Windows DPI setting, it does now offer a default "page zoom" option:    Unfortunately there is no zoom level that matches my current DPI setting: 136% (131dpi).  Version: 10.0.648.133  Zoom flag  I tried scoducks' suggestion of the new hidden dpi flag. It's truly awful. It seems to cause Chrome to simply re-scale the final rendered Window; causing text to become blurry (rather than sharper): The close dialog says there are two off-topic votes, but none of the off-topic reasons have votes next to them I've found strange behavior when closing this  - I definitely see that there are 3 closing votes and 2 of them are at "Off-topic" section:   -but there are no explanations on section itself:   -while, normally, it's expected that it will appear. In custom comments section there are also no closing-votes displayed.   Perhaps it's just my browser (which is FF 26 x64 under Win) - so marking this as a "possible bug". Thank you for your attention. How would I find a minimum weight spanning tree for W? There is a way to use my Galaxy tab s like a wacom table, on linux? How to call a function in a Twig file Let's say I create a function in a module file:  function _get_test() {   return 'test'; }   How can I call this in any Twig file? For example *.html.twig, page.html.twig, node.html.twig etc.   OR   How can I pass a variable from PHP to Twig and display in any Twig file.  For example *.html.twig, page.html.twig, node.html.twig etc. trouble installing pygame on ubuntu 16.04 LTS I had a hard time installing pygame on my ubuntu 16.04 LTS. I use python 3. these are the steps I took to install pygame:  1.first I installed pip:  sudo python3 get-pip.py   this is the output of running pip --version:  pip 10.0.1 from /usr/local/lib/python3.5/dist-packages/pip (python 3.5)    I executed the following commands:   sudo apt-get install python3-dev mercurial  sudo apt-get install libsdl-image1.2-dev libsdl2-dev libsdl-ttf2.0-dev   then I executed the following command:   pip install --user hg+http://bitbucket.org/pygame/pygame  and this is the result in terminal:  Collecting hg+http://bitbucket.org/pygame/pygame   Cloning hg http://bitbucket.org/pygame/pygame to /tmp/pip-req-build-hxy86__i abort: error: Connection reset by peer Command "hg clone --noupdate -q http://bitbucket.org/pygame/pygame /tmp/pip-req-build-hxy86__i" failed with error code 255 in None   and it fails to install pygame. what should I do?? If $n = p_1^{a_1} ... p_r^{a_r}$ the set of nilpotents of $\mathbb{Z}_n$ is $(p_1 p_2 ... p_{r-1} p_r)\Bbb Z_n$ I used to work as a consultant and have been spoiled with nice looking slides. For instance, being able to create slides that have 2, 3, or 4 graphs (perfectly positioned and with nice headers!) at the click of a mouse button via macros.  Similarly, there are many other kinds of word slides that had multiple columns, etc. that would be nice to recreate as well as objects like "main point" boxes at the bottom that summarize a main point and ways to add a transparent highlight to any part of the screen.  Is this kind of functionality far beyond anything that LaTeX presentations can do or is there an archive somewhere of code for making more intricate presentations?