{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Trailing_Zeros"],"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":8,"n_cols":3,"rows_kept":8,"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,\"FormulaWOT\")","v":"=(A3<>0)*SUM(--(A3=ROUND(A3,-ROW(INDIRECT(\"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,\"FormulaWOT\")","v":"=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)))))))"}]
[{"$f":"-A3","v":-300},{"$f":"(A5<>0)*SUM(--(A5=ROUND(A5,-ROW(INDIRECT(\"1:15\")))))","v":2},{"$f":"sbGetCell(B5,\"FormulaWOT\")","v":"=(A5<>0)*SUM(--(A5=ROUND(A5,-ROW(INDIRECT(\"1:15\")))))"}]
[{"$f":"-A4","v":-6000},{"$f":"LEN(ABS(A6))-LEN(SUM(MID(ABS(A6),LEN(ABS(A6))+1-ROW(INDIRECT(\"1:\"&LEN(ABS(A6)))),1)*10^(LEN(ABS(A6))-ROW(INDIRECT(\"1:\"&LEN(ABS(A6)))))))","v":3},{"$f":"sbGetCell(B6,\"FormulaWOT\")","v":"=LEN(ABS(A6))-LEN(SUM(MID(ABS(A6),LEN(ABS(A6))+1-ROW(INDIRECT(\"1:\"&LEN(ABS(A6)))),1)*10^(LEN(ABS(A6))-ROW(INDIRECT(\"1:\"&LEN(ABS(A6)))))))"}]
[{"$f":"--(RANDBETWEEN(-20,20)&REPT(\"0\",RANDBETWEEN(0,15)))","v":700000000000000},{"$f":"(A7<>0)*SUM(--(A7=ROUND(A7,-ROW(INDIRECT(\"1:15\")))))","v":14},{"$f":"sbGetCell(B7,\"FormulaWOT\")","v":"=(A7<>0)*SUM(--(A7=ROUND(A7,-ROW(INDIRECT(\"1:15\")))))"}]
[{"$f":"A$7","v":700000000000000},{"$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":14},{"$f":"sbGetCell(B8,\"FormulaWOT\")","v":"=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)))))))"}]