Excel unchecking check box vbokcancel macro
Checking if a worksheet-based checkbox is checked
Can bosons that are composed of several fermions occupy the same state? It is generally assumed that there is no limit on how many bosons are allowed to occupy the same quantum mechanical state. However, almost every boson encountered in every-day physics is not a fundamental particle (with the photon being the most prominent exception). They are instead composed of a number of fermions, which can not occupy the same state.  Is it possible for more than one of these composite bosons to be in the same state even though their constituents are not allowed to be in the same state? If the answer is "yes", how does this not contradict the more fundamental viewpoint considering fermions? How to get permission number by string : -rw-r--r-- I need to set the same chmod, how to get number for -rw-r--r-- ? The set of integers $n$ expressible as $n=x^2+xy+y^2$ Let $S$ be the set of integers $n$, such there exist integers $x,y$ with $$n=x^2+xy+y^2$$   Is the implication $$a,b\in S\implies ab\in S$$ true? If yes, how can I prove it?  I worked out $$n\in S\iff 4n\in S$$ and $$n\in S\iff 3n\in S$$ I tried two approaches. The first is to express $$(a^2+ab+b^2)(c^2+cd+d^2)$$ in the form $$f^2+fg+g^2$$ with polynomials $f,g$ with integer coefficients. I however could not find suitable $f$ and $g$. The second approach is based on $$x^2+xy+y^2=\frac{(2x+y)^2+3y^2}{4}$$ If we have $n=x^2+xy+y^2$ , we have $u^2+3v^2=4n$ for some integers $u,v$ with equal parity. The main problem of this approach is to consider the equal parity. Any ideas ? Oneboxing a Stack Exchange post using HTTPS does not work When you post a link from Stack Exchange into the chatbox using HTTPS, the link does not onebox. However, if you change the link to HTTP, it works. See the screenshot below:    HTTPS URLs should onebox, too. After logging in on terminal with user name and password, how do I start the GUI? What are the differences between Generics in C# and Java... and Templates in C++? We have this large database (>1TB) that we intend to "shrink".  The database revolves around one main entity, let's call it "Visit".  For discussion, let's say it is a database for a medical practice.  There are a total of 30 visit "types", such as procedure, annual, follow-up, immunisation etc, each of which is a subsidary table to "Visit", e.g. "visit_immuno".  The database has accummulated some 12 years of data since 2000.  Someone has proposed that we keep about 3 years of data in the "live" version and have the rest live in an "old_data" database.  The date is ONLY stored in the "Visit" table since it is normalised.  The Visit table also contains a ROWVERSION column and a BIGINT pseudo-identity (clustered) column.  For all intents and purposes, let's say the clustering key is populated by a SEQUENCE (SQL Server 2012 Enterprise) - we shall name it cid.  The visit.date is not always in the same order as the clustering key, for example when a doctor goes on extended visitations and returns with his "briefcase" of data, it gets merged into the main table.  There are also some updates to the "visit" table that will cause the ROWVERSION column to be out of sync with both the cid and date columns - to put it simply, neither ROWVERSION nor cid would make suitable partition keys for this reason.  The business rule for removing data from the "live" is that the visit.date must be greater than 36 months and a child visit_payment record must exist.  Also, the "old_data" database does not contain any of the base tables except visit%.  So we end up with:  Live DB (daily use) - All tables Old-Data DB - older data for the visit% tables  The proposal calls for a Combined DB that is a shell containing Synonyms to ALL the base tables in the Live DB (except visit%) plus Views that UNION ALL across the visit% tables in the two databases.  Assuming the same indexes are created in the Old-Data DB, will the queries perform well on the UNION-ALL Views?  What type of query patterns might trip up the execution plan for the UNION-ALL Views? Shell script- To fetch the content from the specific tag at all occurrence using shell scripting I have an XML file on my server. In that file, I have many tags in which there is a tag for example, "container" tag. I need to fetch the content of all the container tags content separately. Many thanks in advance. apt-get autoremove wants to remove linux headers If $[G:H]=n$, then $g^{n!}\in H$ for all $g\in G$. Does C# have anything comparable to Python's list comprehensions? What are the tools to help import my data into Salesforce I am switching from old CRM and looking for easy to use tools to import my data What counter balances gravity here? Lets consider a stone tied to one end of a massless and unstretchable string... Now if i'll start rotating, it will form a conical pendulum &amp; then the equilibrium is achived when the pendulum attains horizontal circular motion.... Now to maintain that state we give a constant force to string.... Here, which force counterbalances gravity? Is it the torque due to applied force cancels out the torque due to gravity?  The angle θ changes from 0 to 90° Cancelling special & general relativistic effects We know that for a GPS we need to make a correction for both general and special relativity: general relativity predicts that clocks go slower in a higher gravitational field (the clock aboard a GPS satellite moves faster than a clock down on Earth), while special Relativity predicts that a moving clock is slower than the stationary one (slow the clock compared to the one down on Earth).  My question is this: is it possible, in theory, to set up an orbit so that these two effects cancel each other out, allowing a clock on board a GPS satellite to tick as if it were on Earth? Is there a distance at which the special and general effects cancel?  Sorry if this is a stupid question - I'm still not entirely confident with the theory of general relativity. How do you select elements based on their style? Using jQuery, how would you find elements which have a particular style (eg: float: left), regardless of whether it's an inline style or one defined in a CSS file? How do I fix my locale issue? Getting MAC Address I need a cross platform method of determining the MAC address of a computer at run time.  For windows the 'wmi' module can be used and the only method under Linux I could find was to run ifconfig and run a regex across its output.  I don't like using a package that only works on one OS, and parsing the output of another program doesn't seem very elegant not to mention error prone.   Does anyone know a cross platform method (windows and linux) method to get the MAC address?    If not, does anyone know any more elegant methods then those I listed above? I am having trouble finding out why the white space between my paragraphs is variable. Sorry, I am not allowed to post images but sometimes there is no white space (like it should be), just an indent to denote that a new paragraph has started. While sometimes the paragraphs start with an indent AND there is (sometimes substantial and thus variable) white space between the last sentence of the previous paragraph and the first sentence of the new paragraph.  In my tex file, there is no difference between what I do in the first and second examples of my text: just two hard returns to denote the start of a new paragraph. I was wondering whether it could be due to placement of figures and footnotes but I have no idea how to change it. I don't mind a little variable white space between paragraphs but the above example is too extreme for my taste. Thanks for your advice! Where do I find the current C or C++ standard documents? New post formatting Update 3 It took me longer than I wanted, but I’ve got some updates for you on our s-prose component. You can see the  with my thinking over at our design system’s repo. It does the following:  Spreads s-prose headers out from paragraphs for better grouping. Tightens up s-prose paragraphs a bit, and made sure spacing under headings are more consistent. Replaces all s-prose margins internal to the component with a CSS variable var(--s-prose-spacing) so our users can more easily tinker with it in their browsers and user scripts. Kills trailing margins in s-prose  You can see  of content at our Stacks documentation.  Update 2 I’ve split the difference between the original 1.3 line-height and the proposed 1.6 line-height. We’re now at 1.5, with additional refinements to spacing between elements. I’ve also reduced line height within code blocks back to near the original value.  Update 1 This is now live.  We’re doing a bit of refactoring on our post formatting. Currently, we apply a single class with both layout and styling called .post-text. Our first goal is to separate layout from our text styles. Simple enough! However, our current post styling has a few missing spots and areas for improvements. Using our  as a sandbox, we’ve beefed up our styling and created a new component called .s-prose. It’s designed to offer styling for everything the  spec allows. This should allow us to add Stack Overflow-flavored styling anywhere we need to consume Markdown—questions and answers, of course, but also things like user profiles. Our .s-prose component adds:  Proper formatting for   Further header support and better spacing there  Additional blockquote refinements.  Refinements for revealing spoilers. We now reveal this on click / tap for a more consistent experience across devices—fewer accidental reveals as well, since it’s no longer a :hover interaction. Clicking again does not hide the spoiler. We also now add a badge to the top right corner. You can see how these work on our . It looks something like this:   This is a spoiler  It has two lines   General refinements to spacing including nested lists, images within lists  Sizing variations for different contexts. We offer xs, sm, and md variations of the .s-prose component.   As with everything, our prose component is a work in progress. We think we’ve got a heck of a start to a reusable component. We plan on going live with the new component network wide on Thursday, August 27, 2020. We’ll edit this post if that changes. If you see something funky, let us know. Some things are intended but might feel like regressions—images have a slightly different baseline—but others may have slipped through the cracks.