http://www.tacx.com/en/products/trainers/neo-smart

This is a thing of beauty, but my god it is expensive.

This is a thing of beauty, but my god it is expensive.

Likes: wexford and Musashi13

- Thread starter baribari
- Start date

This is a thing of beauty, but my god it is expensive.

Likes: wexford and Musashi13

I have been optimising formulas in Excel today.

I managed to get this one;

=round(sum(100-sum(sum((128-7)-match(A1,$A$7:$A$128,0))/121)*100),2)&" %"

down to...

=match(A1,$A$7:$A$128,0)/count(A7:A128)

The first formula was thrown together to get an end result and to allow for the rest of the spreadsheet to be built quickly. I then went back in and started fine tuning and reducing formulas down as far as I could; this spreadsheet is also used in Google Drive by some people on low speed wifi connections, so I wanted it to be as light as possible. The next iteration was this...

=round(100-sum((DAYS360($A$7,$A$128)-match($A$1,$A$7:$A$128,0))/DAYS360($A$7,$A$128))*100,2)&" %"

Ignoring the round() method at the start, this is essentially;

100-((a-x)/a)*100

I reduced it step by step...

100-(1-x/a)*100

100*(1-(1-(x/a)))

100*(1-1+(x/a)))

100*(x/a)

Then applied this logic to the formula, giving me...

100*match($A$1,$A$7:$A$128,0)/days360($A$7,$A$128)

Then I found out that the days360() method doesn't give an accurate size for applying % to a single day, so shifted to the count() method instead, ignoring the date formatting, and just counting rows.

Hope that helps.

I managed to get this one;

=round(sum(100-sum(sum((128-7)-match(A1,$A$7:$A$128,0))/121)*100),2)&" %"

down to...

=match(A1,$A$7:$A$128,0)/count(A7:A128)

The first formula was thrown together to get an end result and to allow for the rest of the spreadsheet to be built quickly. I then went back in and started fine tuning and reducing formulas down as far as I could; this spreadsheet is also used in Google Drive by some people on low speed wifi connections, so I wanted it to be as light as possible. The next iteration was this...

=round(100-sum((DAYS360($A$7,$A$128)-match($A$1,$A$7:$A$128,0))/DAYS360($A$7,$A$128))*100,2)&" %"

Ignoring the round() method at the start, this is essentially;

100-((a-x)/a)*100

I reduced it step by step...

100-(1-x/a)*100

100*(1-(1-(x/a)))

100*(1-1+(x/a)))

100*(x/a)

Then applied this logic to the formula, giving me...

100*match($A$1,$A$7:$A$128,0)/days360($A$7,$A$128)

Then I found out that the days360() method doesn't give an accurate size for applying % to a single day, so shifted to the count() method instead, ignoring the date formatting, and just counting rows.

Hope that helps.

Likes: leicaman

Quiet too.... A lot of money for quiet though.

http://www.dcrainmaker.com/2015/09/trainer-everything-wanted.html

http://www.dcrainmaker.com/2015/09/trainer-everything-wanted.html

Will happily live with my KICKR as its not loud but I was disappointed that a fairly obvious minor design change would have reduced the noise considerably. With the belt entirely removed, the Tacx takes that on even further and simplifies the design at the same time

- This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.

By continuing to use this site, you are consenting to our use of cookies.