(public).sospep.events ~ view task ~ CREATE-article

<h1 style="text-align: center;">CREATE-article#</h1>
<h2>[previously]</h2>
<ol>
<li>[2016-04-25]&nbsp;&gt; [00:00] NEW task IN&nbsp;</li>
<ol>
<li>x] # 6113 - CREATE-sheet# # - city rank - ranking Canadian cities for jobs and affordability</li>
<li>x] link - &nbsp;<a href="https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/" target="_blank">https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/</a></li>
<li>x] link v2 -&nbsp;<a href="https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/edit?pref=2&amp;pli=1#gid=2041784613" target="_blank">https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/edit?pref=2&amp;pli=1#gid=2041784613</a>&nbsp;</li>
<li>] link v3r -&nbsp;https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/edit?pref=2&amp;pli=1#gid=32750585&nbsp;</li>
</ol>
<li>&gt; [00:00] UPDATE task IN&nbsp;</li>
<ol>
<li>x] # # - post -r/canada -&nbsp;<a href="https://www.reddit.com/r/canada/comments/4gdiif/so_where_in_canada_has_jobs_and_affordable/" target="_blank">so where in Canada has jobs AND affordable housing</a>,&nbsp;<a href="https://www.reddit.com/r/canada/comments/4gdiif/so_where_in_canada_has_jobs_and_affordable/d2h87wd" target="_blank">post comment</a></li>
</ol>
<li>&gt; [00:00] UPDATE article IN</li>
<ol>
<li>x] # 802 -&nbsp;<a href="/view/article?id=802" target="_blank">canadas economic overview</a>&nbsp;- ] ADD reference for Labour stats table - includes secondary cities like Brandon, Chilliwack, ...</li>
</ol>
<li>[00:00] UPDATE task</li>
<ol>
<li>x] # # - ADD 16 more NEW cities,&nbsp;</li>
<li>x] # # - ADD data for NEW cities</li>
<li>x] # # - ADD columns for ] Population, ] employment %, ] Job Listings, , ] JL per Pop,&nbsp;</li>
<li>x] # # - ADD new DATA for all cities</li>
<li>x] # # - re-Rank cities with additional criteria of ] emp %, ] JL per Pop,</li>
<li>x] # # - set as public</li>
</ol>
<li>[2016-04-27]&nbsp;&gt; [00:00] NEW task IN&nbsp;</li>
<ol>
<li>x] # 6113 - ADD 3rd sheet, duplicate V2,&nbsp;</li>
<li>x] # # - ADD column for Cost Of Living(COL), calculate avg mthly income, subtract&nbsp;</li>
<li>x] NEW COLUMN = COL - (hh income / 12) - (house / 100 * 500)&nbsp;</li>
</ol>
<li>[00:00] NEW task IN&nbsp;</li>
<ol>
<li>x] # # - g.qry - "rank canadian cities employment"</li>
<li>x]&nbsp;<a href="http://www.huffingtonpost.ca/2016/01/13/best-cities-for-work-canada-bmo_n_8970958.html" target="_blank">http://www.huffingtonpost.ca/2016/01/13/best-cities-for-work-canada-bmo_n_8970958.html</a> - huff post ranks top 10 canadian cities for job prospects, LIST = Guelph, Regina, , Quebec City, Moncton, Vancouver, Edmonton, Toronto, Kingston, London, Winnipeg. Criteria = unemploment, employment, pop growth, employment growth, x] prev articles on site -&nbsp;<a href="http://www.huffingtonpost.ca/news/best-cities-for-jobs-canada/" target="_blank">http://www.huffingtonpost.ca/news/best-cities-for-jobs-canada/</a>&nbsp;</li>
<li>] BMO report - cited by huffpost article,&nbsp;</li>
<li>x] moneysense.ca - <a href="http://www.moneysense.ca/canadas-best-places-to-live-2015-full-ranking/" target="_blank">Best places to live in Canada 2015</a>- has annual rankings of 200 ish Canadian Cities - by multiple criteria including, income, weather, crime, ...</li>
</ol>
<li>[2016-04-29]&nbsp;[13:00] NEW article IN nations/canada/economy</li>
<ol>
<li>[x] # 5090 -&nbsp;<a href="/view/article?id=5090" target="_blank">Top Canadian cities with Jobs and Affordable Houses</a>&nbsp;</li>
</ol>
<li>[2017-11-18] NEW task IN edits</li>
<ol>
<li>[x]&nbsp;SECTION = where, removed the following items(4) from the article &nbsp;</li>
<li>] VIEW THE FULL LIST</li>
<ol>
<li>]&nbsp;<a href="https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/edit?pref=2&amp;pli=1#gid=2041784613" target="_blank">https://docs.google.com/spreadsheets/d/1tWhulZNnJ_XGTyMieQUbEjJncBDzdOKvB9mNRjrVT6I/edit?pref=2&amp;pli=1#gid=2041784613</a></li>
</ol>
<li>] version 1</li>
<ol>
<li>] 16 Canadian cities ranked by 3 criteria, criteria ] unemployment rate, ] median household income, ] average&nbsp;</li>
</ol>
<li>] version 2</li>
<ol>
<li>] add 16 more Canadian Cites, added 2 additional ranking criteria, criteria added = ] job listing per population, ]&nbsp;</li>
</ol>
<li>] version 3</li>
<ol>
<li>] add Cost of Living Column, Cities ranked by &nbsp;&nbsp;</li>
<li>] add color coding for city size, &nbsp;highlight green = large city &gt; 1M, highligh orange = medium city &gt; 500,&nbsp;</li>
</ol></ol>
<li>[2017-11-18] NEW task IN edits</li>
<ol>
<li>[x] SECTION = example, removed text listing of cities</li>
<li>] Regina</li>
<li>] Guelph</li>
<li>] Saskatoon</li>
<li>] Kingston&nbsp;</li>
<li>] Victoria</li>
<li>] Edmonton</li>
<li>] Oshawa</li>
<li>] Calgary&nbsp;</li>
<li>] Brantford</li>
<li>] Kitchener/Waterloo/Cambridge</li>
<li>] Winnipeg</li>
<li>] Peterborough</li>
<li>] Quebec City</li>
<li>] Vancouver</li>
<li>] Montreal</li>
<li>] Abbotsford-Mission&nbsp;</li>
</ol>
<li>[2017-11-18] NEW task IN edits</li>
<ol>
<li>[x] changed the title,&nbsp;</li>
<li>[x] replaced the list cities with image of spreadsheet , version 3r</li>
</ol>
<li>&nbsp;</li>
</ol>
<h2>[currently]</h2>
<ol>
<li>[2017-11-20][00:00] NEW task IN money PURCH&nbsp;</li>
<ol>
<li>[] UPDATE - ] canadian house prices -&nbsp;</li>
<li>[] -&gt; job market -&gt; search&nbsp;</li>
<li>[] g? top canadian cities with jobs</li>
<li>[]&nbsp;http://www.huffingtonpost.ca/2017/05/25/best-cities-jobs-affordable-homes-2017_n_16705874.html</li>
</ol>
<li>] &nbsp;</li>
</ol>
<h2>[next]</h2>
<ol>
<li>] LIST CITIES ADD = ] Sudbury, ] North Bay, ] Nanaimo, ] Courtney, ] Kamloops,</li>
<li>] http://www.canadastop100.com/</li>
<li>
<div>] <a href="http://www.canadianbusiness.com/lists-and-rankings/best-jobs/2016-urban-planner-canadas-hottest-job/" target="_blank">How booming cities made urban planning Canada&rsquo;s hottest job</a>&nbsp;r/canada <a href="https://www.reddit.com/r/canada/comments/4gdjbg/how_booming_cities_made_urban_planning_canadas/" target="_blank">comments</a>&nbsp;</div>
</li>
<li>] SITE = <a href="https://teleport.org/cities/vancouver/" target="_blank">compare cities globally</a>&nbsp;- includes "startup data", r/canada <a href="https://www.reddit.com/r/canada/comments/4h0r6f/toronto_vancouver_montreal_calgary_ao_compared_to/" target="_blank">comments</a>&nbsp;</li>
<li>] NEW task IN UPDATE</li>
<ol>
<li>[2017-11-19] g? = top canadian cities for jobs and affordable homes</li>
<li>] r# 1 - http://www.huffingtonpost.ca/2017/05/25/best-cities-jobs-affordable-homes-2017_n_16705874.html&nbsp;</li>
</ol>
<li>]&nbsp;</li>
</ol>
<div>&nbsp;&nbsp;</div>
<div>
] city rank - march 2016 ( {reddit} markdown table )
City | Unemployment | House | Income | Rank&nbsp;
-----|:------------:|:-----:|:------:|:------:&nbsp;
Regina|4.6|300|93,670|6
Guelph|3.9|400| 85,423|11
Saskatoon|6.3|300|90,840|15
Kingston|6.0|300|82,950|15
Victoria|5.8|600|84,500|17
Edmonton|6.8|400|98,480|18
Oshawa|6.1|500|87,400|19
Calgary|8.4|475|101,260|21
Brantford|5.8|325|59,665|21
Kit/Wat/Cam|6.2|375|82,160|22
Winnipeg|6.4|300|77,770|23
Peterborough|6.0|300|58,314|23
Quebec|8.3|375|84,160|25
Vancouver|6.1|1,100|73,390|28
Montreal|8.7|375|73,250|32
Abbotsford-Mission|7.1|725|68,310|35
&nbsp;
</div>

~ view task ~ TaskGroup] CONTENT-Data FROM [ Plan] plan-projects IN [ calendars] prj-025-sospep-content-data