Put significance on tens and ones or round to a negative precision [updated!]

I had a situation in Excel where tens and ones are the only significant parts of a any number. For some Polish language-specific issues I have come with the situation that no matter how big number is, I need to know the value of its last two digits or last digit.

For example:

21 --> 21 and 1
56 --> 56 and 6
160 --> 60 and 0
1122 --> 22 and 2
679014 --> 14 and 4
1053405 --> 5 and 5

Learning the fact that ROUND(), ROUNDUP() and ROUNDDOWN() functions in Excel can be used with a negative precision parameter helped me solved this issue.

I am not too good in Excel, so maybe (update!) there are prettier solutions. This one works, however…

Read More “Put significance on tens and ones or round to a negative precision [updated!]”

Introduction to curl

This is just a barely memo about very, very basics of curl. Since curl fetches URLs and data from some endpoints, it can be used for a variety of reasons. I am using to for a very basic (and quick!) API calls tests.

If you’re on Linux, Unix or any of its clones or if you’re on Mac then you most likely have curl. If you’re on Windows, but you’re using Git for Windows (or some similar tool) then you have curl.

So, let’s jump into that basics. Be warned — you will not find here anything that you wouldn’t already knew.

Read More “Introduction to curl”