The tilde operator is actually a function that returns an unevaluated expression, a type of language object. The expression then gets interpreted by modeling functions in a manner that is different than the interpretation of operators operating on numeric objects. The issue here is how formulas and specifically the “+, “:”, and “^” operators in … Read more
Use¹ the following as an array formula. =TEXTJOIN(“–>”, TRUE, IF(LEN(C3:I3), C$2:I$2, “”)) Pre-Excel 2016 versions While you could just string together a series of IF statements, a cleaner alternate might be to write a user defined function (aka UDF). In a standard VBA module code sheet: Function udf_Stitch_Together(r As Range, _ h As Range, _ … Read more
If I have a formula in cell A1 (e.g. = B1 * C1) and I want to run some VBA code each time A1 changes due to updates to either cell B1 or C1 then I can use the following: Private Sub Worksheet_Calculate() Dim target As Range Set target = Range(“A1”) If Not Intersect(target, Range(“A1”)) … Read more
[Dis]claimer: I’m the author/maintainer of xlrd. The documentation references to formula text are about “name” formulas; read the section “Named references, constants, formulas, and macros” near the start of the docs. These formulas are associated sheet-wide or book-wide to a name; they are not associated with individual cells. Examples: PI maps to =22/7, SALES maps … Read more
I isolates or insulates the contents of I( … ) from the gaze of R’s formula parsing code. It allows the standard R operators to work as they would if you used them outside of a formula, rather than being treated as special formula operators. For example: y ~ x + x^2 would, to R, … Read more
Assuming no more than 100 rows try this “array formula” to count the different names in A2:A100 where there is a 1 in the same row in B2:B100: =SUM(IF(FREQUENCY(IF(B2:B100=1,IF(A2:A100<>””,MATCH(A2:A100,A2:A100,0))),ROW(A2:A100)-ROW(A2)+1),1)) confirmed with CTRL+SHIFT+ENTER Note that I say different not unique as the two are not the same
The solution for arguments under 1.7976931348623157E308 (Double.MAX_VALUE) but supporting results with MILLIONS of digits: Since double supports numbers up to MAX_VALUE (for example, 100! in double looks like this: 9.332621544394415E157), there is no problem to use BigDecimal.doubleValue(). But you shouldn’t just do Math.pow(double, double) because if the result is bigger than MAX_VALUE you will just … Read more
Each character is used to represent 6 bits (log2(64) = 6). Therefore 4 chars are used to represent 4 * 6 = 24 bits = 3 bytes. So you need 4*(n/3) chars to represent n bytes, and this needs to be rounded up to a multiple of 4. The number of unused padding chars resulting … Read more
I see a couple issues going on here. First, and I don’t think this is causing any trouble, but let’s make your data frame in one step so you don’t have v1 through v4 floating around both in the global environment as well as in the data frame. Second, let’s just make v2 a factor … Read more
stellar database google for: BSC (Bright star catalog) ~10K stars up to +6.5 mag (naked eye) Hipparcos ~118K stars up to +12 mag (telescopes) and also has parallax (3D coordinates) and many more Hipparcos is mine favorite. both can be downloaded freely in ASCII format from many Astornomy server just google … planets (bodies) You … Read more