How to calculate the Hamming weight of a binary string?
+0
−0
A presently unanswered question on Stack Overflow asks:
Does there exist a popcount function in libreoffice calc?
and clarifies that "I often use BASE(A1;2;8) to show a number in binary".
1 answer
+1
−0
I believe the answer at the moment is "No" but a very simple formula in LibreOffice 5.4.3.2 can achieve the desired result:
=LEN(SUBSTITUTE(B1;0;""))
where B1 contains:
=BASE(A1;2;8)
as valid and A1 contains the number in decimal.
The B1 cell would not be required with this version:
=LEN(SUBSTITUTE(BASE(A1;2;8);0;""))
This converts to binary, strips out the 0s and counts the number of characters left thereafter.
With the appropriate delimiter, should also work at least in Excel, Sheets and OpenOffice Calc.
0 comment threads
1 comment thread