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.
- Export all orders from Shopify.
- Extract orders for the workshop and paste them in to Excel 5x.
- Extract orders for the workbook/quick start bundle and paste them in 2x.
- Extract orders for the quick start pack and paste them in 1x.
- Add a column,
=RAND()
. This gives me a random number between 0 and 1. - Copy/paste values on this column otherwise it changes on every edit or file open.
- Sort the column descending.
- Pick the top 5.
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.