{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Trailing_Zeros","Trailing_Ones"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Trailing_Zeros","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Count trailing zeros"]
["Input","Output","Output formula"]
[300,{"$f":"(A3<>0)*SUM(--(A3=ROUND(A3,-ROW(INDIRECT(\"1:15\")))))","v":2},{"$f":"sbGetCell(B3,\"ShowFormula\")","v":"=(A3<>0)*SUMME(--(A3=RUNDEN(A3;-ZEILE(INDIREKT(\"1:15\")))))"}]
[6000,{"$f":"LEN(ABS(A4))-LEN(SUM(MID(ABS(A4),LEN(ABS(A4))+1-ROW(INDIRECT(\"1:\"&LEN(ABS(A4)))),1)*10^(LEN(ABS(A4))-ROW(INDIRECT(\"1:\"&LEN(ABS(A4)))))))","v":3},{"$f":"sbGetCell(B4,\"ShowFormula\")","v":"=LÄNGE(ABS(A4))-LÄNGE(SUMME(TEIL(ABS(A4);LÄNGE(ABS(A4))+1-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A4))));1)*10^(LÄNGE(ABS(A4))-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A4)))))))"}]
[70000,{"$f":"6+RIGHT(TEXT(ABS(A5),\"0.##############E+00\"),2)-LEN(TEXT(ABS(A5),\"0.##############E+00\"))","v":4},{"$f":"sbGetCell(B5,\"ShowFormula\")","v":"=6+RECHTS(TEXT(ABS(A5);\"0.##############E+00\");2)-LÄNGE(TEXT(ABS(A5);\"0.##############E+00\"))"}]
[8000,{"$f":"(A6<>0)*(LEN(ABS(A6))-LEN(--(\"0.\"&ABS(A6)))+2)","v":3},{"$f":"sbGetCell(B6,\"ShowFormula\")","v":"=(A6<>0)*(LÄNGE(ABS(A6))-LÄNGE(--(\"0.\"&ABS(A6)))+2)"}]
[{"$f":"-A3","v":-300},{"$f":"(A7<>0)*SUM(--(A7=ROUND(A7,-ROW(INDIRECT(\"1:15\")))))","v":2},{"$f":"sbGetCell(B7,\"ShowFormula\")","v":"=(A7<>0)*SUMME(--(A7=RUNDEN(A7;-ZEILE(INDIREKT(\"1:15\")))))"}]
[{"$f":"-A4","v":-6000},{"$f":"LEN(ABS(A8))-LEN(SUM(MID(ABS(A8),LEN(ABS(A8))+1-ROW(INDIRECT(\"1:\"&LEN(ABS(A8)))),1)*10^(LEN(ABS(A8))-ROW(INDIRECT(\"1:\"&LEN(ABS(A8)))))))","v":3},{"$f":"sbGetCell(B8,\"ShowFormula\")","v":"=LÄNGE(ABS(A8))-LÄNGE(SUMME(TEIL(ABS(A8);LÄNGE(ABS(A8))+1-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A8))));1)*10^(LÄNGE(ABS(A8))-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A8)))))))"}]
[{"$f":"-A5","v":-70000},{"$f":"6+RIGHT(TEXT(ABS(A9),\"0.##############E+00\"),2)-LEN(TEXT(ABS(A9),\"0.##############E+00\"))","v":4},{"$f":"sbGetCell(B9,\"ShowFormula\")","v":"=6+RECHTS(TEXT(ABS(A9);\"0.##############E+00\");2)-LÄNGE(TEXT(ABS(A9);\"0.##############E+00\"))"}]
[{"$f":"-A6","v":-8000},{"$f":"(A10<>0)*(LEN(ABS(A10))-LEN(--(\"0.\"&ABS(A10)))+2)","v":3},{"$f":"sbGetCell(B10,\"ShowFormula\")","v":"=(A10<>0)*(LÄNGE(ABS(A10))-LÄNGE(--(\"0.\"&ABS(A10)))+2)"}]
[{"$f":"--(RANDBETWEEN(-20,20)&REPT(\"0\",RANDBETWEEN(0,15)))","v":30000000000000},{"$f":"(A11<>0)*SUM(--(A11=ROUND(A11,-ROW(INDIRECT(\"1:15\")))))","v":13},{"$f":"sbGetCell(B11,\"ShowFormula\")","v":"=(A11<>0)*SUMME(--(A11=RUNDEN(A11;-ZEILE(INDIREKT(\"1:15\")))))"}]
[{"$f":"A$11","v":30000000000000},{"$f":"LEN(ABS(A12))-LEN(SUM(MID(ABS(A12),LEN(ABS(A12))+1-ROW(INDIRECT(\"1:\"&LEN(ABS(A12)))),1)*10^(LEN(ABS(A12))-ROW(INDIRECT(\"1:\"&LEN(ABS(A12)))))))","v":13},{"$f":"sbGetCell(B12,\"ShowFormula\")","v":"=LÄNGE(ABS(A12))-LÄNGE(SUMME(TEIL(ABS(A12);LÄNGE(ABS(A12))+1-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A12))));1)*10^(LÄNGE(ABS(A12))-ZEILE(INDIREKT(\"1:\"&LÄNGE(ABS(A12)))))))"}]
[{"$f":"A$11","v":30000000000000},{"$f":"6+RIGHT(TEXT(ABS(A13),\"0.##############E+00\"),2)-LEN(TEXT(ABS(A13),\"0.##############E+00\"))","v":-17},{"$f":"sbGetCell(B13,\"ShowFormula\")","v":"=6+RECHTS(TEXT(ABS(A13);\"0.##############E+00\");2)-LÄNGE(TEXT(ABS(A13);\"0.##############E+00\"))"}]
[{"$f":"A$11","v":30000000000000},{"$f":"(A14<>0)*(LEN(ABS(A14))-LEN(--(\"0.\"&ABS(A14)))+2)","v":{"$error":"#VALUE!"}},{"$f":"sbGetCell(B14,\"ShowFormula\")","v":"=(A14<>0)*(LÄNGE(ABS(A14))-LÄNGE(--(\"0.\"&ABS(A14)))+2)"}]

{"sheet":"Trailing_Ones","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Count trailing ones"]
["Input","Output",{"$f":"(ABS(B2)<>1)*(LEN(SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(B2),\"0\",\"2\"),\"1\",\"0\"))-LEN(--(\"0.\"&SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(B2),\"0\",\"2\"),\"1\",\"0\")))+2)","v":{"$error":"#VALUE!"}}]
[211,{"$f":"(ABS(A3)<>1)*(LEN(SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A3),\"0\",\"2\"),\"1\",\"0\"))-LEN(--(\"0.\"&SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A3),\"0\",\"2\"),\"1\",\"0\")))+2)","v":2},{"$f":"sbGetCell(B3,\"ShowFormula\")","v":"=(ABS(A3)<>1)*(LÄNGE(WECHSELN(WECHSELN(\"2\"&ABS(A3);\"0\";\"2\");\"1\";\"0\"))-LÄNGE(--(\"0.\"&WECHSELN(WECHSELN(\"2\"&ABS(A3);\"0\";\"2\");\"1\";\"0\")))+2)"}]
[{"$f":"-A3","v":-211},{"$f":"(ABS(A4)<>1)*(LEN(SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A4),\"0\",\"2\"),\"1\",\"0\"))-LEN(--(\"0.\"&SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A4),\"0\",\"2\"),\"1\",\"0\")))+2)","v":2},{"$f":"sbGetCell(B4,\"ShowFormula\")","v":"=(ABS(A4)<>1)*(LÄNGE(WECHSELN(WECHSELN(\"2\"&ABS(A4);\"0\";\"2\");\"1\";\"0\"))-LÄNGE(--(\"0.\"&WECHSELN(WECHSELN(\"2\"&ABS(A4);\"0\";\"2\");\"1\";\"0\")))+2)"}]
[{"$f":"--(RANDBETWEEN(-20,20)&REPT(\"1\",RANDBETWEEN(0,15)))","v":17111},{"$f":"(ABS(A5)<>1)*(LEN(SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A5),\"0\",\"2\"),\"1\",\"0\"))-LEN(--(\"0.\"&SUBSTITUTE(SUBSTITUTE(\"2\"&ABS(A5),\"0\",\"2\"),\"1\",\"0\")))+2)","v":{"$error":"#VALUE!"}},{"$f":"sbGetCell(B5,\"ShowFormula\")","v":"=(ABS(A5)<>1)*(LÄNGE(WECHSELN(WECHSELN(\"2\"&ABS(A5);\"0\";\"2\");\"1\";\"0\"))-LÄNGE(--(\"0.\"&WECHSELN(WECHSELN(\"2\"&ABS(A5);\"0\";\"2\");\"1\";\"0\")))+2)"}]