Smart Way to Buy a Kindle


Ever since the first e-ink readers came out I was fascinated by their simplicity – they made a new market for people who like to read, who like the convenience and often otherwise would not be able to afford this hobby.

And then came Kindle and it instantly became the most loved reader and I started to understand why. I will not go too much into details and all I can say is it ticked off all the right boxes:

  • Long battery life – lasts for weeks with single charge of couple of hours. For the last few months I have only charged it three times.
  • Durability – I tend to act clumsy sometimes and I have dropped my Kindle on the floor but surprisingly it leaves neither scratches nor dents on the surface or the screen. I don’t even need a case to cover the device (if I opted for case it would cost almost as much as my Kindle itself).
  • Display – since the screen has neither glare nor reflection I can spend hours reading without making my eyes tired. I could never do such thing on an iPad.
  • Price point – since I am only looking for a dedicated reader I don’t care about touchscreen or a screen with colours. Lack of touchscreen also ensures that I will not accidentally flip the page.
  • Weight and size – it is small enough to slip into my jeans back pocket or in my blazer, not to mention my book bag/rucksack. So whenever I am out or got some time to kill – I can read instead of being idle. Size is perfect for holding the device in one hand.
  • Simple design and clean user interface – even my six-year-old niece has no problem using a Kindle. The build in Wi-Fi works great as I can get my content just by emailing my account and the device will recognise the common formats (txt, doc, pdf, mobi etc.)
  • Further costs – I have an option to read Classical books for free or buy cheap Kindle version books (often cheaper than paperback). However often I will get a free PDF book and use converter to Kindle format (*.MOBI) so the layout is good on my screen. Lately I just find the online articles I want to read and send email them as attachment to my kindle so I can read it on my way home.

Now back to the reason I started this blog post – how to get a good deal when choosing a Kindle. At first I looked at the site where the basic version is sold for £69 (with tax) and they do not provide the option to buy used/refurbished. Then I checked the (US site) to compare the price and, as it is common with many items, they sell exactly the same item for $69 with special offers (non intrusive ads on screensaver and a tiny ribbon at the bottom of the home screen) but then they also offer used/refurbished Kindles – so I saw one for $49 with a free delivery which works out around £33. So I got myself a Kindle in a perfect conditional for less than half the price. So I placed my order around the time I went to New York to collect it. If I ever want to upgrade or sell it – I can sell it for around £40-£50 without problem as they retain their value. Might even make a small profit!

Conclusion: Do your homework and you can get yourself a great deal. In this case, I bought Kindle which changed the whole reading experience and I tend to read way more than I use to which enriches my life and knowledge. Needless to say, I feel like an ambassador for Kindle and I highly recommend it to anyone who is into reading.


A Must Have For Any Credit Controller

In my line of work I have often come across the situation where we (the company I work for) have received a payment with no payment details and it is unable to match the payment to any open invoices.  When the customer has paid oldest-first or the list of open invoices is single-digit it is very easy to do the matching. However when you have to find five out of 50 invoices, things get trickier.

I identified the problem and search for the web and, as usual, Google has answer for (almost) anything.

I came across a VBA/ Macro-enable Excel solution where you enter number of possible  outcomes (1), target value / receipt (2), and list all invoices that should be matched (3) and with a click of a button you get your results.


Example of how to match payment with a list of open invoices – this is extremely helpful for any Credit Controller / Sales Ledger

All you need is a basic knowledge of VBA code or how macros work in Excel:

  1. Open Excel and save as macro-enabled workbook.
  2. format the page to your liking (or similar to layout in my example above)
  3. go to developer tab and create a macro and paste the code (see below)
  4. create a button and assign the macro
  5. save the workbook and all done.

Code is below. I cannot remember where I found it but I am grateful to the wonderful person who made it.

Sub startSearch()
 'The selection should be a single contiguous range in a single column. _
 The first cell indicates the number of solutions wanted. Specify zero for all. _
 The 2nd cell is the target value. _
 The rest of the cells are the values available for matching. _
 The output is in the column adjacent to the one containing the input data.

 If Not TypeOf Selection Is Range Then GoTo ErrXIT
 If Selection.Areas.Count > 1 Or Selection.Columns.Count > 1 Then GoTo ErrXIT
 If Selection.Rows.Count < 3 Then GoTo ErrXIT

 Dim TargetVal, Rslt(), InArr(), StartTime As Date, MaxSoln As Integer, _
 HaveRandomNegatives As Boolean
 StartTime = Now()
 MaxSoln = Selection.Cells(1).Value
 TargetVal = Selection.Cells(2).Value
 InArr = Application.WorksheetFunction.Transpose( _
 Selection.Offset(2, 0).Resize(Selection.Rows.Count - 2).Value)
 HaveRandomNegatives = checkRandomNegatives(InArr)
 If Not HaveRandomNegatives Then
 ElseIf MsgBox("At least 1 negative number is present between positive numbers" _
 & vbNewLine _
 & "It may take a lot longer to search for matches." & vbNewLine _
 & "OK to continue else Cancel", vbOKCancel) = vbCancel Then
 Exit Sub
 End If
 ReDim Rslt(0)
 recursiveMatch MaxSoln, TargetVal, InArr, HaveRandomNegatives, _
 LBound(InArr), 0, 0.00000001, _
 Rslt, "", ", "
 Rslt(UBound(Rslt)) = Format(Now, "hh:mm:ss")
 ReDim Preserve Rslt(UBound(Rslt) + 1)
 Rslt(UBound(Rslt)) = Format(StartTime, "hh:mm:ss")
 Selection.Offset(0, 1).Resize(ArrLen(Rslt), 1).Value = _
 Exit Sub
 MsgBox "Please select cells in a single column before using this macro" & vbNewLine _
 & "The selection should be a single contiguous range in a single column." & vbNewLine _
 & "The first cell indicates the number of solutions wanted. Specify zero for all." & vbNewLine _
 & "The 2nd cell is the target value." & vbNewLine _
 & "The rest of the cells are the values available for matching." & vbNewLine _
 & "The output is in the column adjacent to the one containing the input data."
 End Sub

Saving Money on Transport

Cycling London

I used to work and live in North London within five minutes’ distance and it worked out quite well as I spend little no time and my monthly work-related travel expenses were only about £20 which is close to nothing when many people spend around £100-£160 per month (depending on how far from work you live). So when I got an offer to work in central London for couple of grand I had to consider that if I buy travel card it will equate to over £1K of my gross salary so the net increase in my pay would not be that big. So I was looking for a ways to make my travel arrangement more cost effective without sacrificing much of the convenient (and as it turned out I actually gained extra benefits and save time).


Few months after I started my new job I was introduced to ride2work government scheme where participating employers give their employees benefit of interest free 12-month bike finance where payments are deducted from your gross instead of net salary – which essentially means that you are saving extra 20% of bike’s (and accessories’) value as you have then reduced your taxable income. In my case I could get any bike from Evans Cycles. The certificate itself allows you to buy a new bike and any relevant equipment and accessories. So in my case I opted for medium price range bike @ £650 which was marked down to £550 and added extra accessories worth £100 or so (I also got £25 free accessories voucher when I buy a bicycle). Therefore instead of paying £700 in one go, I paid only £550 in equal payments of £46 (taking into account tax savings).

Cycling + Transport for London (TfL)

It takes just over 10 miles one-way to get to work which is 45 min by Tube, 1hr 20min by bus and about 45-50min by bike. I tried to cycle couple of times and got used to the route to work and made decision to aim for 2-3 times per week (which is enough effort yet gives me enough time in between to recover from the exercise), eight months a year (March – October) when it’s light and warm. I have seen some hard core brothers and sisters out there who cycle year round but I have not prepared myself to this yet.  In the off days from cycling I get to work early in the morning taking advantage of off-peak pricing (Zone 1-4, £2.70 per ride) and go back home by bus (£1.40). The other four months I use public transport daily. Fair enough, I don’t always follow the same routine of off-peak Tube + bus, as sometimes I need to save time the traffic jams make the bus journey horrendous and so I don’t mind spending little bit extra (difference of £2.40 for peak-time Tube versus bus ride). But I also spend one month away from London on holiday so my workings kind of balance out.

Bottom line

I have estimated that my annual spend for work related commute is therefore around £800 per year which is saving of around £950 (yearly travel card Zone 1-4 – £1,744) or rather £1,216 (monthly travel card £167.50 x 12 months). First year savings are diminished by upfront cost – investment in bike and accessories – so it comes to only £400 – £666. Second year onwards, however, there is little to no expense as you can maintain your bike yourself for free. So I am looking at about 50% savings and more if I decide to cycle more frequent. This excludes any additional health benefits (free cardio workout) and saves me from getting costly gym membership which many people don’t really use and then feel guilty about their own foolishness when they signed up for year’s contract to begin with.

So those of you who are looking for cost optimization, this is win-win situation for your health and your wallet.  I have been doing this for only a year but I foresee myself cycling more often in the future.