Microsoft Power Map Preview for Excel Getting Started

1     What is Power Map?

Microsoft Power Map for Excel is a three-dimensional (3-D) data visualization tool for Microsoft Excel 2013 which provides a powerful method for people to look at information in new ways. It enables the data discoveries that might not be seen in traditional two-dimensional (2-D) tables and charts. With Power Map you can plot geographic and temporal data visually, analyze that data on a 3-D globe and over time, and create visual tours to share with others.

NOTE: Power Map and Project Codename GeoFlow” are the same. “GeoFlow” was the codename we used for Power Map in the current preview release that’s available in the Microsoft Download Center.

With Power Map you can:

  1. Map Data: plot more than a million rows of data in 3-D, visually on Bing maps from an Excel worksheet table or the Data Model in Excel.
  2. Discover Insights: gain new understandings by seeing your data in geographic space and seeing time-stamped data change over time.
  3. Share Stories: capture screenshots and build cinematic, guided video tours that can be shared broadly, engaging audiences like never before. Tours can be exported to video and shared that way as well.

This preview of Power Map supports Arabic, Japanese, Spanish and English versions of Office Pro Plus.

Download the whole tutorial online:




The Situationist Drawing Device was developed as a desire to extend the capacity of the body to act in the world. It is an extension to our body, we wear it to use the equipment, we navigate through space to experience a new perception of the environment. In connecting various parts of the body, the device records a journey taken in an altered state of perception through drawing. A choreographic notation of vision and movement are interpreted from the markings on the drawing board. The device is designed and fabricated such that when it is used on site, the interaction between the human body and this specific site condition is heightened through the existence of the intermediary and interpretative tool. The device provided the initial reading of the site and was conceived as a concept model for the ideas that I developed for the Scrap Metal Refinery. The project emerged at the boundary, the point at which two conditions meet. Bordering, yet disconnected, a place for dwelling, learning and play exists alongside a place of industry amongst the discards of society. The site is located in Dunkirk, Nottingham. It is on the boarder between two communities, residential and industrial, separated by a rail bridge. Intrigued by the two different conditions, a threshold, under the rail bridge, I began experimenting through the development of a spatial device to dissolve the boundary conditions. Device Concept

As each eye retina receives different images, both conditions blur into one and simultaneously alternate – phasing in and out over the other. This blurring effect, as known as retinal rivalry, creates a new perception of the site. Device was initially adapted from Pseudoscope [Greek, false view] which is a binoucular instrument that reverses depth perception. The idea of reversing left and right eye vision was adapted to reverse forward and backward vision.


Some Public Housing Institution

Chicago Housing Authority (CHA)  the largest owner of rental housing in the city of Chicago

The most important program of CHA :  The Housing Choice Vouchers

CHA’s Housing Choice Voucher (HCV) Program allows low-income families to rent quality housing in the private market via federal funds provided by the U.S. Department of Housing and Urban Development (HUD). Through the HCV Program, CHA pays a portion of eligible families’ rent each month directly to the Property Owner/Manager. Participating families can use their vouchers to rent a house or apartment from private Property Owners throughout the city of Chicago

References links:

Federal Housing Administration (FHA) –The Federal Housing Administration, generally known as “FHA”, provides mortgage insurance on loans made by FHA-approved lenders throughout the United States and its territories.

This video shows that how does FHA loans work.

http ://

I will keep finding something to supplement this blog


Collecting Data by sensors / The role of Infrared Cameras in Mold inspections

Mold Problem = Moisture Problem <= Environment Problem <Living condition>

Thermal Imaging has now been in place for a number of years within the building industry and has been used to find problems with building materials, such as: hidden water leaks, leaks within the HVAC system, general plumbing leaks and faulty electrical and mechanical systems. For example, thermal imaging has been successfully utilized to help determine whether or not there are any significant energy losses due the  incorrect amount of insulation or even missing insulation, thermal imaging has also been used successfully to help locate loose electrical connections or overheated breaker boxes by identifying “hot spots”.

While this equipment cannot readily detect mold, it does hold the “key” to finding mold by quickly and accurately identifying the conditions necessary for mold to be present. By identifying variances in surface temperature, thermal imaging has the ability to help us quickly find moisture incursions. The variances in the surface temperatures often mean that there has recently been a moisture incursion and that variance in the temperature of the moisture present behind the surface is affecting the surface temperature, which is easily detected by high quality infrared cameras. Thermal imaging cameras have quickly become the “must have tool” for IAQ Professionals as they can help to expedite the investigation process significantly, thereby providing investigators with opportunities to increase the number of investigation that can be completed on a daily basis.

This video tells us about the process of detecting by using the thermal camera


Tiny House Eco Village for the Homeless

Architect Arthur Dyson is working with construction management students at Fresno State to create an unprecedented “Eco-Village” of tiny homes for homeless folks. The homes will be made of recycled materials – pallet flooring and framing, waterproofed cardboard walls, aluminum can roofing – and some donated materials from Lowe’s, according to The Fresno Bee.

The green community would have several tiny homes amidst fruit trees andlandscaping, while a main building would house kitchen and bathroom facilities, as well as shops for residents to sell things they’ve made or grown.

The first homes are under construction, as pictured, and will be as small as 80 square feet. But they don’t have a plot selected for the Eco-Village and will need one soon.

Fresno State contributed $20,000 to the effort, and Gregory Barfield, the city’s point man in preventing homelessness, is ready to help Dyson and company find an adequate site for the community.

If successful, it seems like Dyson’s Eco-Village could provide a model for future communities elsewhere. Students get valuable experience in sustainability and construction, while landfill material gets reused and folks in need get a cozy shelter from the elements.



The Suburbs: Poverty’s New Frontier

The Sun-Times‘s Francine Knowles has a good piece today on suburban poverty. I’ve been reading about that for awhile, so what surprised me was the statistics about income:

An analysis of Census data done by the center shows that in Cook County, the median householdincome last year was $51,466, down $8,625 from 1999 and down $3,351 from 2006. In DuPage County, the median was $72,471, down $16,362 from 1999 and down $7,203 from 2006. In Lake County, it was $74,705, down $12,932 from 1999 and down $6,583 from 2006.

What’s interesting is that the income drop in Lake and DuPage, which both have median incomes well above the state average (Cook County’s is almost exactly average), far outpaces job loss. During the recession, unemployment in DuPage increased less than it did in Cook County; in Lake, the increase was about the same. Yet both counties saw a 10 percent drop in inflation-adjusted income.

In 2010 the Brookings Institution took a deep look at suburban poverty in Chicago, Los Angeles, and Washington D.C. Among its more dramatic findings was the increase in suburbanites seeking help for the first time:


The survey’s map of suburban Chicago was also interesting: a similar pattern as the city, with a wealthier core surrounded by more impoverished areas.