Friday, February 17, 2017

What do consumers value in smartphones?

As part of the Little Book of Value (#LBOV), I am writing a number of case studies, including:

- Value of smartphones - see draft case here
- Value of NBN; national infrastructure
- Value of new products (denting the universe); Apple and iPhone

The #LBOV is a collaborative writing project at Github, but the pics need to be on a URL, so I will post the pics here for linking from Github. Please add you Value stories as a link to this post, or other #LBOV posts on this blog.

Here are the images of what consumers valued in their smartphones. All images CC-BY.
Please also refer to my Phd at Ferrers (2013), full reference at: http://dx.doi.org/10.6084/m9.figshare.680002.



Fig 1. What do consumers value in smartphones? A small sample.


Fig 2. Count of value elements by consumer - the PhD sample.


Fig 3. Comparing value dimensions across consumers - the PhD sample


Fig 4. Theoretical saturation - Value Concepts - the PhD sample


Thursday, February 2, 2017

NBN coming to Vic 3166 - I made a map. Here's how.

See the map (v.1) I made (with 40 datapoints) at:
https://twitter.com/ValueMgmt/status/827009730870521856 
I made a (v.2) map (with 60 datapoints) at:
https://t.co/zd8F86Z9am

Method

If you want to repeat this for your area, here's how I did it.

Getting Started

  • Lat/Long: I use a Mac, and its Map program provides an easy way to turn an address into a Lat Long. You can also use maps.google.com.
  • Spreadsheet. I used a Google Sheet. You can also load data into excel (csv) and drop into Google Maps.
  • Google Maps. You need a Google login for this.

Making the Map

  1. Create Google Sheet (or spreadsheet) with four columns
  2. A. Address B.Lat C.Long D. NBN Status – in rollout (yes/no)
  3. Get the Lat Long. In Apple Maps, pick an address, Drop a pin = Right Click. Click (i). Copy address into Column A. Copy Lat/ Long in Col B,C. Alternatively, in Google Maps, right click What's here to get the Lat/Long of any point. You can also find a Lat/Long with Google Maps API; by inserting and address into: http://maps.googleapis.com/maps/api/geocode/json?address=ADDR where ADDR = 12carlislecrescent,hughesdale,vic eg Link

  4. Paste address into NBN map checker:
  5. http://www.nbnco.com.au/connect-home-or-business/check-your-address.html
    This gives rollout status. In Hughesdale it was either (1) (Available: Apr – Jun) = yes or (2) (Still finalising) = no.

  6. Paste Address status (yes/no) into Col. D.
  7. Gather a list of addresses you want to map... I did about 25 before I made a map. Then the map helped pick where to check next.
  8. Go to Google Maps: https://www.google.com.au/maps/
  9. -> Menu -> Your places -> Maps -> Create Map -> Add Layer -> select Google Sheet -> indicate Lat/Long fields -> indicate NBN Status: Yes/No field
    This places all your address points on a map.
    Add a title and description to explain what area you are mapping.

  10. Colour code the points into different colours for NBN Status: Yes/No.
  11. Select Layer -> Uniform Style -> Uniform Style -> Style by Data Column -> Col D. (NBN Status).

  12. When you add new data to your spreadsheet, you need to (but maybe there is an easier way) readd the layer: Add layer -> select Google Sheet i.e. repeat Step 6,7. Delete the old layer: Choose layer -> layer options (three vertical dots) -> delete this layer.
  13. Add polygon to show the boundary of rollout for the region.
  14. Post to Whirlpool / Twitter for comments: Maps -> Share -> Change: anyone with the link can View – copy/paste URL

  15. Enjoy!