Bear Pro subscription prize draw

Since we launched the Quick Start: 'Life admin' pack I've been running a prize draw for 1 year of Bear Pro, worth US$30.

The kind folks at Bear gave me 5 App Store codes. Another reason why it's my favourite notes app. :-)

Here's how I did it. I won't show full working as it might leak customer data.

  1. Export all orders from Shopify.
  2. Extract orders for the workshop and paste them in to Excel 5x.
  3. Extract orders for the workbook/quick start bundle and paste them in 2x.
  4. Extract orders for the quick start pack and paste them in 1x.
  5. Add a column, =RAND(). This gives me a random number between 0 and 1.
  6. Copy/paste values on this column otherwise it changes on every edit or file open.
  7. Sort the column descending.
  8. Pick the top 5.
A screenshot of Excel, showing my working.

I just emailed those 5 people. They might not need the code, in which case I'll mail the next people on the list until they're all gone.