国外牛人用excel做的动态仪表盘优秀案例教材表格推荐下载.xlsx

1、Percaptia income,weather or living conditionsYou may ignore the Margin of Error data（provided in extreme right in the data tables）.You may submit more than one entry.For voting&selecting winners only 1 entry from each individual is considered.Important DatesContest start date9th of April,2014Last da

2、te for submission20th of April,2014Last day of submission,hurry up!How to submit your entry?EmailSend to:Subject:Datavis contest 2014Include:Your workbook,Your name,Email Address&Version of Excel used to make itFacebookJoin chandoo.org fan page（Click here）Send your entry as a message（with workbook a

3、s attachment）Include:Version of Excel used to make itWhat do you get?First prizeiPad（Latest version）16 GBSecond prizeiPad Mini（latest version）16 GBThird prize（2 nos）Samsung Galaxy Tab 3How winners are selectedWinners will be selected by voting and a panel of judges（to be revealed）.If there is a tie,

4、Judges decision will be given more weightage.Fine PrintPrizes will be delivered thru A.If you are located in a country where shipping Amazon goods is not possible（or prohibitively expensive）you will beoffered a choice of either getting money payment or purchase from a local website.You also agree th

5、at Chandoo.org reserves the right to showcase your files,share them,use them in courses&training programs or any other publication asdeemed fit.You agree to share the copy-right of your workbook with Chandoo.org indefinetly for no compensation.Chandoo.org may get in touch with you if we need any cla

6、rifications or we are unable to use your file.Chandoo.org reserves the right to disqualify a contest entry based on sole discretion.For updates on rules,dates&policies,please click below link:http:/chandoo.org/wp/2014/04/09/visualize-state-migration-contest/Visit Contest WebsiteVisit Chandoo.orgYou

7、can use Macros&VBA to add interaction to charts.（Code must be commented clearly and sources should be credited）You may submit more than one entry.For voting&selecting winners only 1 entry from each individual is considered.Last day of submission,hurry up!Winners will be selected by voting and a pane

8、l of judges（to be revealed）.If there is a tie,Judges decision will be given more weightage.Prizes will be delivered thru A.If you are located in a country where shipping Amazon goods is not possible（or prohibitively expensive）you will beoffered a choice of either getting money payment or purchase fr

9、om a local website.You also agree that Chandoo.org reserves the right to showcase your files,share them,use them in courses&training programs or any other publication asdeemed fit.You agree to share the copy-right of your workbook with Chandoo.org indefinetly for no compensation.Chandoo.org may get

10、in touch with you if we need any clarifications or we are unable to use your file.Chandoo.org reserves the right to disqualify a contest entry based on sole discretion.Data visualization of the internal migration in the U.S.from 2010 to 2012Prepared by:Jorge SupelanoExcel Version:2013Select a year20

11、12.and see the general trendsSelect a StateAlabama.and see the trend for 2012 in that statePopulation decreased 0.1%Top 5 states represent 51.9%of all the arrivalsTop 5 states represent 54.7%of all the departuresNote:Due to Margin of Errors（which were ignored）,some numbers may not add upTotal Moveme

12、ntsMost and least active statesArrivalsDepartures108,823105,565（88,979）（135,811）Net MigrationMost active statesFloridaTexasNew JerseyNew York19.0%10.7%10.1%7.1%4.9%People arrived from.Top 5 statesGeorgia Florida Tennessee Texas North Carolina 25,000 20,000 15,000 10,000 5,000 0 17.0%12.7%11.1%9.2%4.

13、7%People departed to.Top 5 statesFlorida Georgia Tennessee Texas Mississippi 20,000 15,000 10,000 5,000 0 Out of 310 million people in the U.S in 2012,roughly 7 million（or 2.3%）,settled in a new stateand 38 million（or 12.2%）moved within their state481,496953,7891,723,117655,46514.7%8.9%7.5%Movements

14、 within a stateMost and least active statesNevadaArizonaNew YorkNew Jersey%of total state population2.1%1.1%（1.0%）（7.0%）Where the impact is bigger%of state population gained and lostNorth DakotaDelawareNew JerseyAlaskaInternalmigration590,32613%Settlers fromother states2%Sameresidence 1year ago104,600109,210Loss4,610Gain0Arrivals and DeparturesArrivedDepartedGeneral trends2012CounterTotal pop310,212,7551Same residence 1 year ago263,612,59685.5%2Different residence,same state 1 year ago37,696,59712.2%3Intrastate migration7,070,3452.3%4308,379,538100.0%56Out o